Using the table Student and Course already available in the given workspace, execute the following queries. 1. Write an SQL query to display course ID, course name and student name right outer joined student with course table using student id. 2. Write an SQL query to display course ID and student name joining student table and course table using student id column for students whose age<19. 3. Write an SQL query to display the student id, age and course id from the student table joined with course table for English course. 4. Write an SQL query to student id, name, age, course id, course name, level name of the student table full outer joined with course table for the Maths course.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Using the table Student and Course already available in the given workspace, execute
the following queries.
1. Write an SQL query to display course ID, course name and student name
right outer joined student with course table using student id.
2. Write an SQL query to display course ID and student name joining student
table and course table using student id column for students whose age<19.
3. Write an SQL query to display the student id, age and course id from the
student table joined with course table for English course.
4. Write an SQL query to student id, name, age, course id, course name, level
name of the student table full outer joined with course table for the Maths course.
Transcribed Image Text:Using the table Student and Course already available in the given workspace, execute the following queries. 1. Write an SQL query to display course ID, course name and student name right outer joined student with course table using student id. 2. Write an SQL query to display course ID and student name joining student table and course table using student id column for students whose age<19. 3. Write an SQL query to display the student id, age and course id from the student table joined with course table for English course. 4. Write an SQL query to student id, name, age, course id, course name, level name of the student table full outer joined with course table for the Maths course.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education