Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone answer these quickly? Thank you! SQL language. Query #1: Display all the fields from the Order Details table for the following order numbers:

Can someone answer these quickly? Thank you!

SQL language.

Query #1: Display all the fields from the Order Details table for the following order numbers: 10251, 10258, 10266 or 10371. Order the list by unit price in descending order. Query #2: List the supplier id, company name, contact name and contact title for those suppliers who are from the United States and who do NOT have a fax number. Use the Suppliers table. Query #3: Display the employee first name, last name and full name in the following format: last name comma first name such as King, Robert. This list should ONLY include employees with the job title of Sales Representative that were born in the 1960s (1960 - 1969). Use the Employees table. Query #4: List the customer ID, order date, freight, ship name and ship address from the Orders table whose customer id starts with the letter K and whose freight cost is 100 or more. Order the list by ship city (ASC) and ship zipcode (DESC). Query #5: List the customer ID, order date, ship date and the number of days it took to ship the product after the order was made. This will be a calculated field and YOU MUST USE the DateDiff function. The alias name for the calculated field should be Days to Process Order. This query should include orders that meet the following criteria: the order date must have been made within the first 15 days of April in 2017. The Days to Process the Order should be between 1 and 10 days. Use the Orders table. Query #6: List the contact name, contact title and country for those customers who are located in Brazil or France and whose contact title is any manager type role. Use the Customer table. Order the list by country. Query #7:. List the Product ID, product name, Unit Price and 2 calculated fields: UnitPrice with a 2 % increase and UnitPrice with a 3% increase. Only include the following products.:

The current unit price must be within the range of 10 to 30 dollars. The number of nits on stock must be within 40 to 100 units. The categoryid must Not be a (1 or 2). Use the Products table.

Query #8: List the product id, name, supplier id, unit price, units on stock from the Products table for the top 15 most expensive products. Use the With Ties within your Select statement.

Query #9: Display all of the fields from the OrderDetails table along with the following calculated field (UnitPrice * Quantity) * (1 - Discount) AS ProductSale. Only display records that meet the following criteria: the quantity ordered is within the range of 20 to 40 and the product was discounted for the order.

Query #10: Simply list one column of information - the different countries that exist in the Customers table. A country should only be listed once.

image text in transcribed

Suppliers Categories Employees EmployeelD Orders OrderlD ContactTitle Order Details Products Customers Shippers ContactTitle Region Address RegionDescription Region EmployeeTerritories EmployeelD TerritorylD Country Territories TerritorylD Phone

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DATABASE Administrator Make A Difference

Authors: Mohciine Elmourabit

1st Edition

B0CGM7XG75, 978-1722657802

More Books

Students also viewed these Databases questions

Question

4. Ashantis sense of humor keeps the class positive.

Answered: 1 week ago