1.Make a Powerpoint presentation on India and the G20: Prioritizing education technology
for global growth
2.Table “Emp” is shown below. Write commands in SQL for (i) to (iii) and output for (iv)
and (v)
i. To display list of all employees
below 25 years old.
ii. To list names and respective
salaries in descending order of
salary.
iii. To list names and addresses of
those persons who have ‘Delhi’ in
their address.
iv. SELECT Name, Salary FROM
Emp where salary between 50000 and 70000;
v. SELECT Name, phone from emp where phone like ‘99%’;
3. Mrs. Sen entered the following SQL statement to display all Salespersons of the cities
“Chennai” and ‘Mumbai’ from the table ‘Sales’.
Sc
od
e N
am
e
C
i
t
y
101 Aakriti Mumb
a
i
102 Aman Chenn
a
103 Banit Delhi
104 Fauzia Mumb
a
SELECT * FROM
Sales WHERE
City=‘Chennai’ AND
City=‘Mumbai’;
Rewrite the correct statement, if wrong or write statement is correct.
4. Which clause would you use with Select to achieve the following:
i. To select the values that match with any value in a list of specified values.
ii. Used to display unrepeated values of a column from a table.
5. Consider the following table:
