varchar(30)
nvarchar(100)
Picture 1.1
Question 2:
4 of 4
Paper No: 1
[0.5 mark] Write a query to list Customers living in New York. The result includes columns:
customer_id, first_name, last_name, email and sort in ascending order by last_name,
first_name as follows.
customer_id
1
1
2
first_name
Liam
Emma
last_name email
Johnson
Smith
liam
[email protected]
[email protected]
Picture 2.1
Question 3:
[1 mark]. Write a query to list products with a product_name containing the word 'City'. the
result includes: product_id, product_name, and list_price columns, and sort in ascending
order by product_name.as follows.
Zoom
+ 100%
product_id product_name list_price
1
6
City Lite
259.00
2
7
City Pro
399.00
3
11
E-City 250
1299.00
Picture 3.1
Close
