0
Problem is based on SQL mentioned in Description down help me out
PRACTICAL 1: CREATING A SINGLE TABLE WITHOUT CONSTRAINTS AND FIRING SELECT QUERIES. 1. Friends is an entity set with attributes last name (Lname), first name ( Fname), address, city and age. Convert an entity set to table with suitable data types for attributes. Add 5 meaningful records. Fire the following queries: 1. Display all the tuples of the table. 2. Retrieve first and last name of all friends. 3. Fetch all the friends with age more than 25. 4. Retrieve all friends with Mumbai city and age less than 20 or last name Shah. 5. Retrieve all first and last names with age lies between 20 and 30.
2 Antworten
+ 2
For creating table
https://www.sololearn.com/learn/SQL/1870/
For inserting records
https://www.sololearn.com/learn/SQL/1868/
You can find all of it in the SQL course.
0
Thanks Avinesh