Font size
WorksheetsAIM Finals 2
Total questions: 13
Worksheet time: 13mins
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: students
student_id name course year_level
Add a new student named “Ana” taking “STEM” in Year 1.
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: students
student_id name course year_level
Change the course of student with student_id = 3 to “HUMSS"
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: students
student_id name course year_level
Display all students arranged alphabetically by name.
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: students
student_id name course year_level
Count the total number of students.
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: students
student_id name course year_level
Display the highest year level from the students table
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: products
product_id product_name price stock
Display all products with stock greater than 10.
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: products
product_id product_name price stock
Add a new product named “Keyboard” worth 850 with stock 15.
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: products
product_id product_name price stock
Update the stock of product with product_id = 2 to 30.
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: products
product_id product_name price stock
Display all products arranged from highest price to lowest price.
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table Name: products
product_id product_name price stock
Compute the total stock of all products.
(a)
A WRITE THE CORRECT SQL COMMAND NEEDED TO PERFORM THE TASK.
Table: std
std_id name crs_id
Table: crs
crs_id crs_name
Display all students including those without assigned courses.
(a)
The full name of the Philippine national hero
(a)
The full name of your FAVORITE instructor. 👸
(a)
