Write a query to display students id and first name whose from coimbatore or chennai and born on 8th oct 1997. sort the result set by students id.
Answers
Answer:
Catalog Name:*Kashvi Superior Kurtis*
Fabric: Cotton
Sleeve Length: 3/4 Sleeves
Pattern: Printed
Combo of: Single
Sizes:S (Bust Size: 36 in, Size Length: 45 in)
XL (Bust Size: 42 in, Size Length: 45 in)
L (Bust Size: 40 in, Size Length: 45 in)
M (Bust Size: 38 in, Size Length: 45 in)
XXL (Bust Size: 44 in, Size Length: 45 in)
Designs: 5
Easy Returns Available In Case Of Any Issue
*Proof of Safe Delivery! Click to know on Safety Standards of Delivery Partners- https://ltl.sh/y_nZrAV3
Explanation:
Catalog Name:*Kashvi Superior Kurtis*
Fabric: Cotton
Sleeve Length: 3/4 Sleeves
Pattern: Printed
Combo of: Single
Sizes:S (Bust Size: 36 in, Size Length: 45 in)
XL (Bust Size: 42 in, Size Length: 45 in)
L (Bust Size: 40 in, Size Length: 45 in)
M (Bust Size: 38 in, Size Length: 45 in)
XXL (Bust Size: 44 in, Size Length: 45 in)
Designs: 5
Easy Returns Available In Case Of Any Issue
*Proof of Safe Delivery! Click to know on Safety Standards of Delivery Partners- https://ltl.sh/y_nZrAV3
Catalog Name:*Kashvi Superior Kurtis*
Fabric: Cotton
Sleeve Length: 3/4 Sleeves
Pattern: Printed
Combo of: Single
Sizes:S (Bust Size: 36 in, Size Length: 45 in)
XL (Bust Size: 42 in, Size Length: 45 in)
L (Bust Size: 40 in, Size Length: 45 in)
M (Bust Size: 38 in, Size Length: 45 in)
XXL (Bust Size: 44 in, Size Length: 45 in)
Designs: 5
Easy Returns Available In Case Of Any Issue
*Proof of Safe Delivery! Click to know on Safety Standards of Delivery Partners- https://ltl.sh/y_nZrAV3
Answer:
select studId, firstname from student
where ((city='Coimbatore' OR city='Chennai') AND dob='8-Oct-1997')
order by studId;
Explanation:
Select studentid and name from student relation and nest the where clause as city can be either coimbatore or chennai but dob has to be 8th Oct 1997 hence usage of 'And' and sort by the student id by default it takes as ascending.