The InstantRide Management team considers creating a new team for Car Maintenance. The new team needs to find/list the cars that are used more than average with the usage count. Collect the information of all rides and consolidate over the Car IDs. You need to create a three level SQL statement. Firstly, you need to COUNT the number of rows in TRAVELS and GROUP BY the CAR ID field. Then you need to calculate the AVG of the data to find the average usage of the cars. Finally, you need to return CAR_ID and the TRAVELS count (as the Usages column) filtered to only values greater than the calculated average. Task

The InstantRide Management team considers creating a new team for Car Maintenance. The new team needs to find/list the cars that are used more than average with the usage count. Collect the information of all rides and consolidate over the Car IDs. You need to create a three level SQL statement. Firstly, you need to COUNT the number of rows in TRAVELS and GROUP BY the CAR ID field. Then you need to calculate the AVG of the data to find the average usage of the cars. Finally, you need to return CAR_ID and the TRAVELS count (as the Usages column) filtered to only values greater than the calculated average. Task

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Using the Online SQL Editor, answer the following questions with screenshots. Link: https://www.programiz.com/sql/online-compiler/ 1. Show all records from the Customers table, sort the result reversed alphabetically by Country. Answer(screenshot of code & output from SQL Editor). 2. Show the complete names (first & last name), age, and country from the Customers table, sort the result alphabetically, first by last name, then, by first name. Answer(screenshot of code & output from SQL Editor). 3. Provide the last three records of the customers’ complete names (first & last name), but showing only those with ages older than 22 or those living in the United Kingdom. Answer(screenshot of code & output from SQL Editor). 4. Provide all the items and corresponding amounts from the orders table; but showing only items with amounts of 250 and 400; then sort the list according to amount (descending order); finally, change the name of amount to“Items_on_sale”.…
List the item ID, description, and number of units on hand for each item that has between 10 and 30 units on hand, including both 10 and 30. Provide TWO alternative SQL statements to produce the same results
Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image )the question is:2. Get employee details from employee table whose first name starts with 'J', order the result descending.
I NEED HELP WITH THIS QUESTION FOR MY DATABASE MANAGEMENT CLASS FOR SQL DEVELOPER In reporting total_sale by each REP including those who made no sale, which Table joins should be left join. And how to show zero in your report instead of null for reps with no sale.
Question R Write a PL/SQL block to read and display the names of world regions, with a count of the number of countries in each region. Include only those regions having at least 10 countries. Order your output by ascending region name. Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line.
Answer the following questions based on the information in the PATIENT table below. Write SQL queries statement and provide the output of each query. (Screenshot the interface in MySQL that show SQL statement and output for each question). PATIENT PID PNAME AGE ADATE 1001 JAMAL 35 1002 TAN 52 1003 MARIAM 30 1004 JOE 27 1005 SOFEA 19 GENDER 2000-10-28 M 2000-11-20 M 2000-07-16 F 2000-12-18 M 2000-04-25 F 4. List the name of the youngest patient
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to display the product class whose average price is at least 50
What is the minimum number of database requests you need to write for an inventory update for both PRODUCT and PART? Using proper SQL syntax for an Oracle database, write each request below.
I want to write the SQL to create the tables for the ERD attached, but I also want to add this to the tables: rental date, due date, and return date so that I can support overdue queries. I also want it so each table has primary keys and foreign keys. I want it so the tables have at least 4 rows of data. How can I do this? Thank you for your help as I learn more about SQL and table creation.
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to retrieve all details of products whose name is "Watermelon" and whose color is "green".
Use SQL Developer.
Answer the following questions based on the information in the PATIENT table below. Write SQL queries statement and provide the output of each query. (Screenshot the interface in MySQL that show SQL statement and output for each question). PATIENT PID 1001 JAMAL 35 1002 TAN 52 PNAME AGE ADATE 1003 MARIAM 30 1004 JOE 27 1005 SOFEA 19 GENDER 2000-10-28 M 2000-11-20 M 2000-07-16 F 2000-12-18 M 2000-04-25 F 2. Find the name of patient who admits on the same date as Sofea.