Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 DepartmentsStep 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