Exercise: 4

Find all records from the Printer table containing data about color printers.

Solution

SELECT *
FROM printer
WHERE color = 'y'