# 3.2 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.2_Assignment__Writing_Basic_SELECT_Queries/3.2_Assignment.pdf
pages: 1

---
[page 1]
Assignment / Activity: Practice the SELECT Statement 
 Title: Explore and Query a Sample Users Table 
 Instructions  : Use  https://sqliteonline.com  or any  online SQL tool to complete the following. 
 Q1. Create a table named  users  with the following  columns: 
 ●  id  (INTEGER, Primary Key) 
 ●  name  (TEXT) 
 ●  email  (TEXT) 
 ●  age  (INTEGER) 
 ●  country  (TEXT) 
 Q2. Insert at least 3 records into the table. 
 Example: 
 INSERT INTO users (id, name, email, age, country) VALUES (1, 'Neha', 'neha@email.com', 24, 
 'India'); 
 Q3. Write a query to fetch only the  name  and  email  of all users. 
 Q4. Write a query to fetch all columns of users who are older than 25. 
 Q5. Write a query to fetch names of users from the country  'India'  .