SELECT * FROM doughnut_ratings WHERE DATE > '2007-07-31'Elle sélectionne les avis qui ont été écrits après le 31 juillet 2007.
CREATE TABLE employees ( emp_no INT NOT NULL AUTO_INCREMENT, birth_date DATE , first_name VARCHAR(14) , last_name VARCHAR(16) NOT NULL, gender ENUM ('M','F') , PRIMARY KEY (emp_no) );
hire_date DATE NOT NULL,
+--------+-------------------------+-----------------+ | number | description | contractor | +--------+-------------------------+-----------------+ | 1 | outside house painting | Murphy | | 2 | kitchen remodel | Valdez | | 3 | wood floor installation | Keller | | 4 | roofing | Jackson | +--------+-------------------------+-----------------+
+------------------+------+-------+--------+------+----------+ | drink_name | cost | carbs | color | ice | calories | +------------------+------+-------+--------+------+----------+ | Blackthorn | 3.00 | 8.40 | yellow | Y | 33 | | Blue Moon | 2.50 | 3.20 | blue | Y | 12 | | Slim Shady | 4.35 | NULL | clear | Y | NULL | +------------------+------+-------+--------+------+----------+