Scribd
Upload
20 views7 pages

Correct Assignment

The document outlines an assignment by Indenga Dortea, focusing on SQL queries related to employee and department data. It includes tasks such as joining tables, filtering results, and modifying the employees table by adding a new column. Additionally, it emphasizes the importance of the employee_id as a primary key that cannot be null.

Uploaded by

ndovemagda2030
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
20 views7 pages

Correct Assignment

The document outlines an assignment by Indenga Dortea, focusing on SQL queries related to employee and department data. It includes tasks such as joining tables, filtering results, and modifying the employees table by adding a new column. Additionally, it emphasizes the importance of the employee_id as a primary key that cannot be null.

Uploaded by

ndovemagda2030
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Assignment 3

Indenga Dortea,230050972

a) I)

ii)

iii)

b)

i) This statement joins employees and departments on employee_id,filters by department_name ‘’IT’’


and groups the result by first_name while computingthe average salary.
ii)

Add a new column named Age of type VARCHAR(30) to the employees table

iii)

-The employee_id cannot be null because it’s a primary key in the employee table.
Question 2

i)

ii)
iii)
iv
Question 3
Question 4

a)

b)

You might also like