[SOLVED] The STRINGIT DATABASE

ASSIGNMENT 3 (Use the STRINGIT DATABASE)

Why are the terms ”field” and ”record” incorrect when referring to column and row

Why is the term ”NULL value” incorrect

How many orders where made from the Sales.Orders table

Get the Shippeddate,the count of Numorders,the count of Shippeddate,the minimum shippeddate as the first ship date,the maximum shippddate as the Latestshipdate

Get the top 3 order details of Total Sales where total sales is defined as the product of the Unitprice and quantity

Get the Ship ID, The total freight greater than 2000 from the Sales.orders table

Get the hire country,hiredate ,the Number of employees hired after 20030101 from the HR.Employees Table

Write a query to return orders that were not shipped yet. Such orders have a NULL in the shippeddate column.

You are requested to return all orders that were placed between February 11,2008 and February 12,2008

If I want to return information about employees from Washington State in the United States, sorted by city and empid

Write a query that returns the orders for customer 77. Such that the rows will be sorted by shipperid. To avoid tiebreakers perform secondary ordering by shipped date and orderid, descending respectively