Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
531 B
1
Indexable
Never
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);