My Educator SQL Exam Chap 2-4 / Questions & Expertly Verified Answers, 2025/ 2026.
Exam Chap 2 - LorenzoShippingDB - Answer:
What is the name of the customer whose Customer ID is 989? - Answer: Select cust_name from customer where cust_id = 989 What is the customer name, the annual revenue and customer type of customer with ID of 1592? - Answer: Select cust_name, annual_revenue, cust_type from customer where cust_id = 1592 What are the truck ID's of trucks that have carried small shipments. Small shipments are defined as those that weigh less than 800 pounds? (HInt: Avoid duplcates.) - Answer: Select distinct truck_id from shipment where weight < 800 Give all the data for shipments weighing over 15000 pounds. (Use *) - Answer: Select * from shipment where weight > 15000 Create a list in alphabetical order of names of customers with more than $10 million in annual revenue - Answer: Select cust_name from customer where annual_revenue > 10000000 order by cust_name What is the customer ID and type of customer for the customer named "Autoware Inc"? -
Answer:
Give names and average monthly revenue of customers having annual revenue exceeding $20 million. Name the column Average_Monthly_Revenue with a literal (note the underscores). 1 / 2
(Hint: Use division.) - Answer: Select cust_name, annual_revenue/12 as Average_Monthly_Revenue from customer where annual_revenue > 20000000 Using the IN operator, give the city names and their populations of the cities in the database in North or South Dakota, Wyoming, or Montana. - Answer: Select city_name, population from city where state IN ('North Dakota', 'South Dakota ','Wyoming','Montana') Give ID's, names, and states of cities with names starting with 'C'. - Answer: Select city_id, city_name, state from city where city_name like 'C%' Give names, states, and areas of cities with names ending with 'City' and with areas greater than 10 but less than 50. Use the BETWEEN operator. - Answer: Select city_name, state, area from city where city_name like '%City' and area between 10 and 50 Give names and states of customers that have a "D" as the third character in their names. (Note: SQL Server data is not case sensitive.) - Answer: Select cust_name, state from customer where cust_name like '__D%' Give names of all customers that are retailers. - Answer: Select cust_name from customer where cust_type = 'retailer' List without duplication all the customer types from the customer table. - Answer: Select distinct cust_type from customer
Give names of all customers who are not retailers. - Answer: select cust_name
from customer where NOT cust_type = 'retailer'
- / 2