Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write an expression in SQL for each of the following queries: F. Find the name and status of all students who are liked by more

image text in transcribed

Write an expression in SQL for each of the following queries:

F. Find the name and status of all students who are liked by more than one other student. G. What is the average number of friends per student? (Your result should be just one number.) H. Find the number of students who are either friends with Tom or are friends of Tom. Do not count Tom, even though technically he is a friend of a friend. I. Find the name and status of the student(s) with the greatest number of friends.

For the following relation schema: Students(ID, name, status) Grade History(ID courselD, courseCredit, grade_point) Friend(ID1,ID2) Likes/ID1, D2) Friend table represents unidirectional relationships .e if id1 = 1510 and id2 = 1381 means 1510 friends with 1381 but not vice versa. Likes table represents unidirectional relationships ie if id = 1689 and id2 = 1709 means 1689 Likes 1709 but not vice versa. The four years of undergraduate education are called: freshman, sophomore, junior, Senior. Students Friend Likes Grade History 10 namo 1025 Rick 1101 Jerry 1247 Shaggy Rogers 1304 Winnie the Pooh 1316 Leonardo 1381 Charlie Brown and Snoopy 1468 Mickey Mouse 1501 Raphael 1510 Bugs Bunny 1641 Scooby-Doo 1651 Scrooge McDuck 1619 Homer Simpson 1709 Tom 1782 Derman 1911 HomerJ. Simpson 1934 Morty 101 IDZ ID1 ID2 1510 1381 1510 1689 1709 1689 1689 1709 1709 1689 1381 1247 1782 1709 1709 1247 1911 1247 1689 1782 1247 1468 1782 1468 1782 1316 1641 1468 1782 1304 1316 1304 1468 1101 1501 1934 1468 1641 1101 1641 1934 1501 1247 1911 1025 1101 1247 1501 1911 1501 1501 1934 1316 1934 1934 1304 1304 1661 1661 1025 DoD card on your ne IS CSEL 0 110 2 FALL HIS CSET 3 310 2021 FALL 1304 CSEL 0 100 2001 FALL 134 CSEL 3 100 2:21 FALL 1316 CSEL 100 2:21 FALL 1316 CSEL 3 400 201 FALL 1481 SENIL 0 10 2021 FALL 1458 CSEL 3 130 2021 FALL 1501 CEL 100 2121 FALL 1501 CSETTL 3 270 2:21 FALL 1611 CSETTL 0 100 2021 FALL 1641 CSETTL 110 20 FALL

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Temporal Databases Research And Practice Lncs 1399

Authors: Opher Etzion ,Sushil Jajodia ,Suryanarayana Sripada

1st Edition

3540645195, 978-3540645191

More Books

Students also viewed these Databases questions