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

Why are the terms ”field” and ”record”
incorrect when referring to column and row
2.
Why is the term ”NULL value” incorrect
3.
How many
orders where made from the Sales.Orders table
4.
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
(JUST WRITE QUERY)
5.
Get the top
3 order details of Total Sales where total sales is defined as the product
of the Unitprice and quantity (JUST WRITE QUERY)
6.
Get the
Ship ID, The total freight greater than 2000 from the Sales.orders table (JUST WRITE QUERY)
7.
Get the
hire country,hiredate ,the Number of employees hired after 20030101 from the
HR.Employees Table (JUST WRITE QUERY)
8.
Write a
query to return orders that were not shipped yet. Such orders have a NULL in
the shippeddate column.
9.
You are
requested to return all orders that were placed between February 11,2008 and
February 12,2008 (JUST WRITE QUERY)
10.
If I want
to return information about employees from Washington State in the United
States, sorted by city and empid (JUST WRITE QUERY)
11.
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 (JUST
WRITE QUERY)

Leave a Reply

Your email address will not be published. Required fields are marked *