Question
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.
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
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