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

7th May 2019, 8:59 AM
Minhaz Ul Islam Prio
Minhaz Ul Islam Prio - avatar
2 Answers
7th May 2019, 9:06 AM
Gordon
Gordon - avatar
+ 1
CREATE VIEW most_abs AS SELECT id, name, absences FROM students ORDER BY absences DESC LIMIT 10;
7th May 2019, 9:44 AM
Prokopios Poulimenos
Prokopios Poulimenos - avatar