Question
3. Create SQL commands to do the following (verifying each works in LiveSQL worksheet area before appending to wk5hw.sql file): 1. Display all records/attribute values
3. Create SQL commands to do the following (verifying each works in LiveSQL worksheet area before appending to wk5hw.sql file):
1. Display all records/attribute values in the COURSE table
2. Display all records/attribute values in the CLASS table
3. Display all records/attribute values in the STUDENT table
4. Display all records/attribute values in the ENROLL table
5. Display all attributes of the record of the student whose STU_NUM is 324299from the STUDENT table
6. Display the last name only of students who have a GPA greater than 2.90 from the STUDENT table Week 5 Homework (35 points) Page 5 of 8 Version FR.10.1.2 12/12/20
7. Display the grades only of the student whose STU_NUM is 324257 from the ENROLL table
what commands will produce these test?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Privacy In Statistical Databases Unesco Chair In Data Privacy International Conference Psd 2008 Istanbul Turkey September 2008 Proceedings Lncs 5262
Authors: Josep Domingo-Ferrer ,Yucel Saygin
2008th Edition
3540874704, 978-3540874706
