What are the queries using this schema 1. What is the name of customer 433? QUER

Question

What are the queries using this schema

1. What is the name of customer 433?

QUERY:

2. What is the destination city of shipment number 3244?

QUERY:

3. What are the truck numbers of trucks that have carried packages (shipments) weighing over 100 pounds? Remove duplicates from the list.

QUERY:

4. Create and alphabetical list of names of customers with more than $10 million in annual revenue.

QUERY:

5. What is the customer ID for Wilson Brothers?

QUERY:

7. Give names of customers who have sent shipments to cities with names starting with "C." Remove duplicates from the list.

QUERY:

8. Give names of customers that have a "D" as the third letter in their names.

QUERY:

9. Give the names of all customers that are retailers.

QUERY:

shipment customer 00| |shipment # aust id weight cust id cust name annual revenue cust_type truck city oO 1 00 |truck.# 1 1 OO cty_name population destination ship_date dr iver name

Explanation / Answer

1. select cust_name from customer where cust_id=433
2. select destination from shipment where shipment_#=3244
3. select distinct truck_# from shipment where weight>100
4. select cust_name from customer where annual_revenue > 10000000 order by cust_name asc
5. select cust_id from customer where cust_name = 'Wilson Brothers'
7. select distinct c.cust_name from customer c inner join shipment s on c.cust_id=s.cust_id where s.destination like 'C%'
8. select cust_name from customer where substr(cust_name, 1, 3) = 'D'
9. select cust_name from customer where cust_type = 'retailers'

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.