Question: Can I get answer for three questions. please its urgent. help me Question 2 Complete the query below so that it returns the order numbers



Can I get answer for three questions. please its urgent. help me
Question 2 Complete the query below so that it returns the order numbers for all orders purchased by customer number 129 (there should be 3 matched records) Not yet answered - 129; SELECT FROM orders Marked out of 100 P Flag question Question 3 Not yet Complete the query below so that it returns the number of Orders that have been resolved (shou return 4). ho SELECT (order_number) answered Marked out of 1.00 FROM orders status - F Flag question Question 4 Not yet answered Complete the query below so that it returns the customer number and payment date for payment made for $100,000 and over in 2020 (which means that orders that equal $100,000 should be included in the range). Should return 2 records. SELECT customer_number, payment_date, amount FROM payments WHERE amount 100000 Marked out of 100 P Flag question payment_date 2019-12-31'; Part 2: Reporting Queries The database stores data in eight discrete tables, which means you will need to apply careful planning when it comes to generating reports. You will need to create four SQL queries to support several reporting scenarios. Complete the query questions in the corresponding Query Questions section of the Database Basics Assignment Questions activity (test your queries with actual values from the database for accuracy). Basic queries that will help prepare you for the assignment questions follow: . How many customers are in the database? What was the amount for the largest order ever fulfilled? How many employees work out of the San Francisco office? What is the most expensive product available? How many customers don't have an assigned employee? CMIS2250 - Database Assignment ERD product_lines products order_details PK,FK1 order number PK product_line HT PK product_code 04 PK,FK2 product code text_description html_description image product_name 0 FK product_line product_scale product_vendor product_description quantity_in_stock buy_price quantity_ordered price_each order_line_number employees PK employee_number HO Ho msrp orders customers PK order number last_name first_name extension email FK office_code FK reports_to job_title PK customer_number order_date required_date shipped_date status comments customer_name contact_first_name contact_last_name phone address_line 1 address_line2 city state 0 FK customer_number offices PK office code payments PK,FK1 customer number city phone address_line 1 address_line2 postal_code country FK sales_rep_employee_number credit limit PK checkNumber payment_date amount state country postal_code territoryStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
