Write an SQL query to answer following question: which instructors are qualified to teach ISM3113 (please select FacultyID, FacultyName)? (first image) 2. Display the course ID and course name for all courses with an ISM prefix (hint: LIKE 'ISM%'): Google how to use LIKE in SQL 3. Display the numbers and names of all courses for which Professor Berndt has been qualified (hint: inner join):
- Write an SQL query to answer following question: which instructors are qualified to teach ISM3113 (please select FacultyID, FacultyName)? (first image)
2. Display the course ID and course name for all courses with an ISM prefix (hint: LIKE 'ISM%'):
Google how to use LIKE in SQL
3. Display the numbers and names of all courses for which Professor Berndt has been qualified (hint: inner join):
4. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212 (display StudentID, StudentName, CourseID, and SectionNo, use inner join):
5. How many courses in section 2714 during semester I-2021?
6. How many students were enrolled in section 2714?
7. Based on the following Customer table, answer following question:(Second imgage)
(1) for each Customer (e.g., customer C), display all other customers who have higher salary than this Customer (e.g., customer C). (use inner join, display each customer’s ID, name, and all higher salaries, you don’t need to display information about the customers who have higher salary.)
(2) for each Customer (e.g., customer C), display all other customers who have higher salary and are younger than this Customer (e.g., customer C).
8. Based on the following table, please find the customers who locate in the same state
sales.customers.
*cusomter_id
first_name
last_name
phone
street
city
state
zip_code
9. . Based on the following table, please display the staff and their corresponding manager in the same store. Please display staff’s full name in one column, manager’s full name in another column, and store_id
sales.staffs
*staff_id
first_name
last_name
phone
active
store_id
mangager_id
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 3 images