13. (10 points) Using either LOAD DATA INFILE or INSERT INTO, add the following

Question

13. (10 points) Using either LOAD DATA INFILE or INSERT INTO, add the following records to the students table: (also found in the MoreStudents.txt file in Week 3-Moode) alderr 1985-05 30 14. (3 points) A couple records were entered incorrectly last week, so you need to UPDATE the data in the following records in the students table: 15. (3 points) Fill in the AdmitDate and GradDate for these records in the students table 16. (1 point) Display all the records in the students table. 17.(1 point) Display the lastnames, majors and admitDate for all the records in the students table. 18. (2 points) Display the firstname, lastname and admitDate for all lstudents who are undedared. You should have 2 records 19. (2 points) Display the lastname, firstname, major and gradate for all students who graduated. You should have 10 20. (3 points) Display the firstname, lastname and major for all students. Sort the results 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 between January 1, 1970 and December 31, 1979. You should have 6 rows 01511 Adv. Databave Conceps Lab Activity 3 Page 2 of 3 23. (4 points) Display the lastname, admitdate and gradate for all students who were admitted between lanuary 1, 1970 and December 31, 1979 for students who graduated. You should have 4 rows. 24. (3 points) Display the lastname, firstname and major for students who are either CIT majors or ae undedared. You should have 4 records. 25. (3 points) Display the lastname, firstname and major for all students who have graduated or are Make undedared. You should have 11 rows. If you only have 10, verify that Tanya Roberts is undedared. any necessary changes 26. (5 points) Display the lastname, firstname and major for all students are OT or undeclared majors and who were admitted between January 1, 1970 and December 31, 1979. You should have 3 rows. If you only have 2, verify that Tanya Roberts is undecdared 27.(3 points) Display all the columns for the student that was admitted first using the LIMIT keyword. Display the output in vertical format. 28. Type in t to stop logging. Exit mysal Exit the command prompt window. 29. Make sure you shut down File(s) to Submit for Grading using the Moodle Submit Lab 3 link in the Week 3 topic by 1155 pm on the due Lab3?72.txt

Explanation / Answer

ANSWER: As per the chegg policy we can solve only first 4 questions when more than 4 questions are given.So here I am giving you the query for first 4 parts.You can repost the other parts.

16): Select* from students;

17):Select lastnames,mazors,admitdate from students;

18):Select firstname,lastname,admitdate from students where mazor ="undeclared";

19): Select lastname, firstname, mazor, graddate from students where garddate >= "0000-00-00";

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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