Question

House
name
Mrs
Mina
1001
document at that time, What will happen?
0.15 Create a table Customer using following fields.
Customer
Title
Fore- Surname
Interest
Street Area City
Number
Number
1000
Ananya Rawat
Gandhi Goa
12
Flower
Street Nagar
Arranging
Miss Karan Sharma 32
K M Naga
Goa Small
Town
Garden
1002 Miss Samar Shah 89 Lotus K Laya
Delhi Small
Avenue
Garden
1003 Mr Pari Luthra 14 Kayra R Mumbai Shrubs
Bridge Mumbai
1004 Mrs Rishabh Sharma 78
L S Delhi Delhi Flower
Vihar
Arranging
Lat ) Create a query that lists the customers having Interest as “Small Gardens'.
b) Create a query that lists the customers with customer number<1003, sorted as per Forenames.
C Create a query that counts total number of people in different cities in the above given table.
Create a query that lists the customers who have same Surname.
Page 3 of 3

Answer 1

Explanation:

0515847

join my quiz.com