this just needs to be the code or statements fir the and it needs to be dine in

Question

this just needs to be the code or statements fir the and it needs to be dine in MySql only.

20.(3 points) Display the firstname, lastname and major for all students. Sort the resulits by major in ascending order, then by lastname descending. 21. (2 points) Display all the records in the students table that were admitted before January 1, 1970- put the output in a vertical format. You should have 2 rows. 22. (3 points) Display the lastname, admitdate and gradate for all students who were admitted betweern anuary 1, 1970 and December 31, 1979. You should have 6 rows INEa1511 Ade. Databne Concepts Lab Acthity i.r1 '1#)@fni 23.(4 points) Display the lastname, admitdate and gradate for all students who were admitted between January 1, 1970 and December 31, 1979 for students who graduated. You should have 4 rows

Explanation / Answer

20.

select firstname, lastname, major from student order by major asc;
select firstname, lastname, major from student order by lastname desc;

21.

select * from student where year < 1970 limit 2; (or)

select * from student where year < '1970' limit 2;

22.

select lastname, admitdate, gradate from students where admitdate between 'January 1, 1970' and 'December 31, 1979' limit 6;

23.

select lastname, admitdate, gradate from students where admitdate between 'January 1, 1970' and 'December 31, 1979' limit 4;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.