Q: Display the names of the states in which customers reside but for
Display the names of the states in which customers reside but for which there is no salesperson residing in that state. There are several ways to write this query. Try to write it without any WHERE cl...
See AnswerQ: Write an SQL query to produce a list of all the products
Write an SQL query to produce a list of all the products (i.e., product description) and the number of times each product has been ordered. Show how you constructed this query using a Venn or other ty...
See AnswerQ: Display the customer ID, name, and order ID for all
Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once.
See AnswerQ: Display the EmployeeID and EmployeeName for those employees who do not possess
Display the EmployeeID and EmployeeName for those employees who do not possess the skill Router. Display the results in order by EmployeeName. Show how you constructed this query using a Venn or other...
See AnswerQ: Display the name of customer 16 and the names of all the
Display the name of customer 16 and the names of all the customers that are in the same zip code as customer 16.
See AnswerQ: A cellular operator needs a database to keep track of its customers
A cellular operator needs a database to keep track of its customers, their subscription plans, and the handsets (mobile phones) that they are using. The E-R diagram in Figure 2-24 illustrates the key...
See AnswerQ: Rewrite your answer to Problem and Exercise 6-71 for each
Rewrite your answer to Problem and Exercise 6-71 for each customer, not just customer 16. Data from Problem and Exercise 6-71: Display the name of customer 16 and the names of all the customers that...
See AnswerQ: Display the customer ID, name, and order ID for all
Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once by showing order ID 0.
See AnswerQ: Show the customer ID and name for all the customers who have
Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.
See AnswerQ: Display the customer names of all customers who have ordered (on
Display the customer names of all customers who have ordered (on the same or different orders) both products with IDs 3 and 4.
See Answer
