No unread replies.No replies. Capture the output of these queries and upload your output screenshot. Run as a script, copy and paste the output to word, and take its screenshot and paste in paint, save the file, and upload the screenshot file. You can also use the following instructions for embedding images: How to embed an image in Canvas textbox . 1. Display the customer number, customer name, order number, and order date for each order. Sort the results by customer number. 2. Display the customer number, customer name, order number, and order date for all orders. Include all customers in the results. For customers that do not have orders, omit the order number and order date. 3. Create a view named TOYS that consists of the item number, description, units on hand, and unit price of each item in category TOY.
Hello Bartleby I need help with this assignment for my Database Management class. Thank you
SQL - D3 (8 weeks)
Capture the output of these queries and upload your output screenshot. Run as a script, copy and paste the output to word, and take its screenshot and paste in paint, save the file, and upload the screenshot file. You can also use the following instructions for embedding images: How to embed an image in Canvas textbox .
1. Display the customer number, customer name, order number, and order date for each order. Sort the results by customer number.
2. Display the customer number, customer name, order number, and order date for all orders. Include all customers in the results. For customers that do not have orders, omit the order number and order date.
3. Create a view named TOYS that consists of the item number, description, units on hand, and unit price of each item in category TOY.
4. List customer number, customer name, rep name, rep number, and Number_Ordered.
5. List item_num, description, total_value (derive it by multiplying num_ordered and quoted_price for each line, and then take total with sum. You will need to join order_line and item tables and employ group by command in your query.
Note: We can add two types of variables on a SELECT statement. 1) Column_Names from tables, and if multiple tables are involved we use table_name.column_name to refer to them, e.g., PC.Emp_Number, 2) Column functions that may enclose column_names. Though Count(*) is also a column function without a column_name. Now the rules. When we display only column functions on a select statement, group by statement is not needed. But, when we have a mix of regular columns and column functions, we must use group by, and we must group by all the columns that are not inside column functions. The group by command must list the regular columns in the same sequence as they appear on a select statement. It's better to first list the regular columns, and then the column functions on a select statement to minimize confusion.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
