Question: Provide only SQL commands as a solution. Exercise: 1:Create the following tables and insert data in to the tables- Student info: DEPARTMENT_ID Stu_name Stu_address 10


Provide only SQL commands as a solution.
Exercise: 1:Create the following tables and insert data in to the tables- Student info: DEPARTMENT_ID Stu_name Stu_address 10 Asif Dhaka 20 Ana Sylhet 30 Bobi Rajshahi 40 Rupa Dhaka 50 Asif Dhaka 60 Robi Khulna 70 Nazrul Khulna 80 Ovi Barisal Employees: Course_id ECE-105 ECE-465 ECE-105 ICE-301 ICE-301 ICE-245 ECE-465 ICE-245 LAST_NAME Getz Davis King Davis Kochhar DEPARTMENT_ID 10 20 20 30 SALARY 3000 1500 2200 5000 7000 40 Departments: DEPARTMENT_ID Sales Marketing Accounts Administration DEPARTMENT_NAME 10 20 30 40 2.Using syntax of join or inner join Show the DEPARTMENT_ID of both Employees and Departments
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
