Question
1. Write an SQL query to list customer first name, last name, customer code for customers who purchased any kind of saw. (hint: p_descript like
1. Write an SQL query to list customer first name, last name, customer code for customers who purchased any kind of saw. (hint: p_descript like *saw*). You need to join the Customer, Product, Vendor, and Invoice tables for this query.
2. Write an SQL query to list customer first name, last name, and the total value of the products that have been purchased by the customer. But the result should be shown in two columns: one column is Name (which is the combination of first name and last name, separated by space or comma), the other column is TotalValue. Only show customers who have purchased more than $100.
CUSTOMER PRODUCT VENDOR INVOICE CUSTOMER PRODUCT VENDOR 1 INVOICE CUSTOMER PRODUCT VENDEOR VI INVOICE CUSTOMER PRODUCT VENDOR INVOICEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started