GradePack

    • Home
    • Blog
Skip to content
bg
bg
bg
bg

Author Archives: Anonymous

How many rows are returned by the following query? SELECT MI…

How many rows are returned by the following query? SELECT MIN(Tip)FROM RideDetail rWHERE NOT EXISTS (SELECT * FROM Driver d WHERE d.DID = r.DID AND d.Region != ‘Atlanta’);

Read Details

Which of the following is/are returned by this query:

Which of the following is/are returned by this query:

Read Details

For all states of this database, which of the following SQL…

For all states of this database, which of the following SQL queries is/are equivalent to this relational tuple calculus query?

Read Details

How many rows are returned by the following query? SELECT DI…

How many rows are returned by the following query? SELECT DID FROM DriverMINUSSELECT DID FROM RideDetail;

Read Details

What DID values are retured by the following query? SELECT D…

What DID values are retured by the following query? SELECT DIDFROM DriverWHERE phone LIKE ‘_0%’;

Read Details

Considering the provided database, after executing the follo…

Considering the provided database, after executing the following update statement: UPDATE RideDetail xSET tip = price * 0.1WHERE price > 15; What RID value(s) would be returned by the following query: SELECT RIDFROM Rider rWHERE NOT EXISTS (SELECT * FROM RideDetail x WHERE x.RID = r.RID AND TIP > 4);

Read Details

Which values are returned from the following nested SQL quer…

Which values are returned from the following nested SQL query? SELECT Dname FROM Driver WHERE DID IN (SELECT DID FROM RideDetail WHERE RID IN (SELECT RID FROM Rider WHERE MemberSince > 2017-01));

Read Details

How many rows are returned by the following query? SELECT Re…

How many rows are returned by the following query? SELECT Region FROM DriverUNIONSELECT RnameFROM Rider;

Read Details

Which query returns the RID of all Riders who have never tak…

Which query returns the RID of all Riders who have never taken a ride?

Read Details

How many superkeys are possible for the RideDetail relation?…

How many superkeys are possible for the RideDetail relation? 

Read Details

Posts pagination

Newer posts 1 … 30 31 32 33 34 … 89,594 Older posts

GradePack

  • Privacy Policy
  • Terms of Service
Top