# 3.5 Assignment

course: Academy — 65-GENAI-for-Engineers
module: Academy/65-GENAI-for-Engineers
type: pdf
source_url: https://personal-learn.armco.dev/files/Academy/65-GENAI-for-Engineers/assignments/3.5_Assignment__Aggregation_Functions/3.5_Assignment.pdf
pages: 1

---
[page 1]
Assignment / Activity: Aggregation in Action 
 Title: Analyze Student Marks Using Aggregation Functions 
 Instructions  : Use  https://sqliteonline.com  or a local  SQL IDE to complete the following: 
 Q1. Create a table called  students  with the following  columns: 
 ●  id  (INTEGER, Primary Key) 
 ●  name  (TEXT) 
 ●  marks  (INTEGER) 
 ●  age  (INTEGER) 
 Q2. Insert at least 5 student records. 
 Example: 
 INSERT INTO students (id, name, marks, age) 
 VALUES (1, 'Anjali', 87, 19); 
 Q3. Write a query to find the total number of students in the table. 
 Q4. Write a query to calculate the average marks. 
 Q5. Write a query to display the minimum and maximum marks together.