/* Simpelfråga */

SELECT dig_id AS 'Dig ID'
FROM dig

/* Använder villkor WHERE */
SELECT * FROM Employees
        ORDER BY 'Role' ASC

/* Använder villkor WHERE */
SELECT * FROM Students
        ORDER BY 'Lastname' ASC

/* Använder villkor WHERE */
SELECT * FROM Artifacts_Report
        ORDER BY 'Dig Site' ASC

/* Använder sig av GROUP BY */

SELECT * FROM Artifacts_Total
--      ORDER BY 'Dig Site' ASC


SELECT * FROM book_loans
        ORDER BY 'Book'