Could you please help me on this MySQL questions. Please send me results if poss
ID: 3699791 • Letter: C
Question
Could you please help me on this MySQL questions. Please send me results if possible. Appreciate your help
Using sub-queries as demonstrated in the textbook, complete the following tasks.
1. Using a sub-query, find the rep number, last name, and first name of each sales rep that represents at least one customer with a credit limit of $10,000. List each sales rep only once in the results.
2. Use a sub-query to list the order number and order date for each order that was placed by Johnson’s Department Store and that contains an order line for a Gas Range. How many rows did your query return?
3. Rewrite step 5 above to list the order number and order date for each order that was placed by Johnson’s Department Store but that does not contain an order line for a Gas Range.
4. Use a sub-query to list the part number, part description, unit price, and item class for each part that has a unit price greater than the unit price of every part in item class AP. Use either the ALL or ANY operator in your query. HINT: Make sure you select the correct operator.
5. If you used ALL in step 7, repeat the exercise using ANY. If you used ANY, repeat the exercise using ALL, and then run the new command. What question does this command answer?
6. Use a sub-query and the IN operator to find the number and name of each customer that placed an order on October 23, 2007.
7. Repeat step 6, but this time use the EXISTS operator in your answer.
8. Using a sub-query, find the number and name of each customer that did not place an order on October 23, 2007.
MySQL premiere Database file:
Explanation / Answer
Please find my answer for Q1.
Please post one question per post as per the chegg policy
SELECT rep.rep_num,rep.last_name,rep.first_name FROM rep WHERE rep.rep_num IN (SELECT rep_num FROM customer WHERE credit_limit>10000);