WITH, TOP and LIMIT
- I Need Querys For The Questions Bellow Without Using Join With Top And Limit 1 (59.79 KiB) Viewed 65 times
I need Querys for the questions bellow, without using JOIN, WITH, TOP and LIMIT
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
I need Querys for the questions bellow, without using JOIN, WITH, TOP and LIMIT
I need Querys for the questions bellow, without using JOIN,
WITH, TOP and LIMIT
Consider a database that stores data about trips on a transport service, with the following tables customer (customer id -> name, city) UN trip (number trip -> cost, date, customer_id, driver_id) driver (driver id -> name, city, rating) Questions: Www 1- Merge 2 different queries using a Union. You must return the driver's name, city, and rating of all drivers. There must be an additional column in which those with a rating greater than 3 are shown "Good Performance", and "Poor Performance" in the rest. 2- Return trips that cost more than the average of all trips. Use a subquery.
WITH, TOP and LIMIT
Consider a database that stores data about trips on a transport service, with the following tables customer (customer id -> name, city) UN trip (number trip -> cost, date, customer_id, driver_id) driver (driver id -> name, city, rating) Questions: Www 1- Merge 2 different queries using a Union. You must return the driver's name, city, and rating of all drivers. There must be an additional column in which those with a rating greater than 3 are shown "Good Performance", and "Poor Performance" in the rest. 2- Return trips that cost more than the average of all trips. Use a subquery.