Course Hero Logo

A9.sql - -finish nine /*Assumptions/Standards 1 - Dates -...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 4 pages.

--finish nine/*Assumptions/Standards1 - Dates -- MM/DD/YYYY unless otherwise specified.2 - Names -- unless otherwise specified, if a problem asks for astudent/instructor name, we want to see the first name and last name columns.2a - alphabetic listing -- means sort it by last name, then first name3 - Start each assignment by pasting the contents of the assignment text intoyour .sql file -- write your SQL statements AFTER the problem statement comment.4 - My preferred contact is: [email protected]5 - I've added a line at the top that says "set echo on;" -- please leave it in6 - If you are asked to sort on a column, don't use DESC unless you arespecifically asked to do so.*/------------------------------------------------------------------------------------------------leave this next line in your scriptset echo on;/*1.Write a statement that displays the first and last name ofthe students that was the first to register for classes */--grab first and last name of students--find the registration list and times for classes--find who was firstselectfirst_name,last_namefromstudentwhereregistration_date = (selectmin(registration_date)fromstudent);

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 4 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Hilton
Tags
nina schorin, Nina Schorin

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture