Untitled
unknown
plain_text
2 years ago
531 B
4
Indexable
SELECT * FROM Payment WHERE amount >= 500; SELECT * FROM Student WHERE DATEADD(YEAR, -20, CURRENT_DATE) > birthday; SELECT * FROM Student WHERE groupnumber = 10 AND DATEADD(YEAR, -20, CURRENT_DATE) < birthday; SELECT * FROM Student WHERE name LIKE 'Mike%' OR groupnumber IN (4, 5, 6); SELECT * FROM Payment WHERE DATEADD(MONTH, -8, CURRENT_DATE) < payment_date; SELECT * FROM Student WHERE name LIKE 'A%'; SELECT * FROM Student WHERE (name LIKE 'Roxi%' AND groupnumber = 4) OR (name LIKE 'Tallie%' AND groupnumber = 9);
Editor is loading...