Untitled
unknown
plain_text
2 years ago
337 B
5
Indexable
SELECT First, Last, (CASE WHEN Died IS NULL THEN (EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM Born)) ELSE (Died - Born) END) AS YearsLived FROM Composer WHERE Born BETWEEN '1600-01-01' AND '1699-12-31' ORDER BY YearsLived ASC, Last ASC, First ASC;
Editor is loading...