Reference no: EM132285396
SQL Questions
- Make a Subquery that show the first 3 letters of the students last name where they are involved in an activity that has a risk greater than 2. Include an alias when appropriate.
- Make a SQL statement that lists the risk and average minimum age of the activity.
Group the SQL statement by risk from lowest to highest.
Use aliases when appropriate.
3. Make a SQL statement that lists students' first name and locker numbers. Include all students regardless of whether or not they have a locker.
Show me the description of the Activity that has an Award cash prize of 80. (Use a JOIN)
4. Make a JOIN query that indicates if any cash prizes are the same as any list prices. This is a unique JOIN that doesn't follow the normal PK/FK link. Use SELECT * for the select statement.
*Two Table Join Required.
5. Make a SQL query that shows majors that have gym lockers in building b.
Don't include any null values for majors. On the output, don't include a major more than once. Order by Major from z to a. Use a JOIN.
6. Make a SQL query that shows Risk and Average List Price of all Activities. Display the average list price in currency appearance.
Don't include rows with a minimum age of 18. Include an aliases where appropriate.