Homework 2-MIS
Create a new Database – HOMEWORK_ASSINGMENT (1 point)
ID
Coffee_name
price
Coffee_origin
1
Espresso
2.50
Brazil
2
Macchiato
3.00
Barzil
3
Cappuccino
3.50
Costa Rica
4
Latte
3.50
Indonesia
5
Americano
3.00
Brazil
6
Flat White
3.50
India
7
Filtre
3.00
Indonesia
From The above table Answer the Following Questions
Create a Table ‘Coffee’ and insert all these value in it. (3 points)
Update the record filtre to Filter and Barzil to Brazil (1 point)
Add column ‘Continent’ (1 point)
Update column continent set ‘Brazil’ to ‘South America’, ‘Costa Rica’ to ‘North America’ and ‘India’ and ‘Indonesia’ to ‘Asia’. (3 points)
Delete records where city is ‘Costa Rica’. (1 point)
3)
ID
First_name
Last_Name
Gender
Phone Number
1
Chris
Martin
M
0112314789
2
Emma
Law
F
01123439899
3
Daniel
Williams
M
03431134211
4
Sarah
Taylor
F
32442145243
5
Katie
Armstrong
F
56924311222
6
Michael
Bluth
M
58294200501
7
Buster
Bluth
M
54929422921
Count the number of ‘M’ in the Gender column (2 point)
Extract data from first name whose name has letter ‘S’ in their name (3 points)
From the the above data extract the records for those whose Last_Name is ‘Bluth’
(3 points)
Explain Different types of Datatypes in SQL . (2 Points)
The post Homework 2-MIS Create a new Database – HOMEWORK_ASSINGMENT (1 point) ID Coffee_name appeared first on PapersSpot.