SQL assignment Week 3

1.

SELECT Title FROM Books ORDER BY Cost

To find out: the cheapest and the most expencive book to produce with the lowest cost on the top

SELECT Title FROM Books ORDER BY Cost DESC

To get the highest price on top and the lowest on bottom

SELECT Title,Cost FROM Books ORDER BY Title,Cost

To sort by Title and Cost. Title first and if there is two Titles with the same name, the Title with the lowest cost is first.

2

SELECT Sold, Count(*) FROM Books GROUP BY Sold

Number of books sold and the number of books that have this salesfigures

SELECT Sum(Sold) AS 'Number of books sold', Price FROM Books GROUP BY Price

At what price is the majority of the books sold

3

SELECT [Title], Round(Price-Cost, 0) AS SalesMargin FROM Books ORDER BY [Title];

What is the sales margin on books sold?

4

DELETE FROM Books WHERE Item = 8

Deleting Item nr8 because it have no sales and have never been printed by this company.