# 3.3 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.3_Assignment__Filtering_Data_Using_WHERE_Clause/3.3_Assignment.pdf
pages: 2

---
[page 1]
Assignment / Activity: Practice Using WHERE Clause 
 Title: Filter Student Records Using SQL 
 Instructions  : Use an online SQL tool like  https://sqliteonline.com  to complete the following: 
 Q1. Create a table named  students  with the following  columns: 
 ●  id  (INTEGER, Primary Key) 
 ●  name  (TEXT) 
 ●  grade  (TEXT) 
 ●  marks  (INTEGER) 
 ●  city  (TEXT) 
 Q2. Insert at least 4 records into the  students  table. 
 Example: 
 INSERT INTO students (id, name, grade, marks, city) VALUES (1, 'Aarav', 'A', 92, 'Delhi'); 
 Q3. Write a query to fetch names of students who scored more than 85. 
 Q4. Write a query to fetch all columns for students who are not from  'Mumbai'  . 
 Q5. Write a query to fetch students whose grade is  'A'  and marks are greater than 90.