0
can anyone solve this ?
Drag and drop from the options below to create a view named ''most_abs'' for the students with the greatest number of absences. ______ _______ most_abs ________ SELECT id, name, absences FROM students ORDER BY absences DESC LIMIT 10; AS/ VIEW /TABLE/ CREATE/ INTO/ SELECT
2 Answers
+ 1
CREATE VIEW most_abs AS
SELECT id, name, absences
FROM students
ORDER BY absences DESC
LIMIT 10;