Question 1 (1 point)

SQL statement to display the publication ID, publication date, cost, and category of each book planned for publication ID number 5, and include ID and Date as column aliases for the first two columns. SELECT Books.PubID AS ID, Books.PubDate AS [Date], Books.Cost, Books.Category FROM Publisher INNER JOIN Books ON Publisher.PubID=Books.PubID WHERE Books.PubID=5;

Question 1 options:

	True
	False

Save

Question 2 (1 point)

SQL statement to display the least expensive retail price book in each book category, and sort the displayed categories in the ascending order. SELECT Min(Books.Retail) AS Lowest, Books.Category FROM Books GROUP BY Books.Category ORDER BY Books.Category DESC;

Question 2 options:

	True
	False

Save

Question 3 (1 point)

SQL statement to display the customer number, city of destination, and shipping date for all shipments with order ID above 3, and restrict the output to shipping dates after January 1, 2013. SELECT Orders.CustomerID, City, ShippingDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID WHERE (Orders.OrderID>2) AND (Orders.ShippingDate >#01/01/2013#);

Question 3 options:

	True
	False

Save

Question 4 (1 point)

INSERT statement to add the following data to the Publisher table:

PubID	PubName	Contact	Phone
6	TEXT AND MORE	John Carter	032-100-7777

INSERT ('6','TEXT AND MORE','John Carter','032-100-7777'),

Question 4 options:

	True
	False

Save