a. Create queries using SQL. Find all the Orders where the quantity ordered was less than 75. Show all fields in the res

[answerhappygod]

A Create Queries Using Sql Find All The Orders Where The Quantity Ordered Was Less Than 75 Show All Fields In The Res 1 (206.87 KiB) Viewed 44 times

a. Create queries using SQL. Find all the Orders where the quantity ordered was less than 75. Show all fields in the results and save the query as ITL Step 1 Query. b. Create a query using the WHERE command to identify the Coaches with offices in the SM building. Save the query as ITL Step 2 Query. c. Use the AND command to identify all the students who have waivers and are qualified academically for sports. Show the Student ID field in the query. Save the query as ITL Step 3 Query. d. Using the NOT command, find all coaches that do not have offices in the JK building. Show the Coach ID field in the query. Save the query as ITL Step 4 Query. e. Using the ORDER BY command, sort the students that are participating in sports by their student ID and then by the name of the sport they are participating in. Sort both in ascending order. Save the query as ITL Step 5 Query. f. Use the AND command to find the football fields that are available in the Fall and sort the results in descending order by FieldID. Save the query as ITL Step 6 Query. g. Group the Orders by Equipment ID and Count the number of orders with quantity ordered of greater than 30. Save the query as ITL Step 7 Query.