Name all the Querys used in Database.
Answers
Answer:
Project Work
Q.7 (A) Bujho and Paheli's house is 3 km. far from the school. Butho go to school bybeth
father and Paheli go to school by car with her father. Buihois father is bite consumes 12
petrol/day whereas Paheli's father's car consumes 2L.diesel day
Ask you father, mother teachers and fill it.
S.No.
Total consumed petrol
by Bujho's father (in Litre
Total consumed diese
by Patelis father in the
1. In a week
2. In February 2020
Flow much Petrol Bufhoss bike
If present cost of Petrol is
consumes in a week?
Answer:
Commands
ALTER TABLE. ALTER TABLE table_name. ADD column_name datatype; ...
AND. SELECT column_name(s) FROM table_name. ...
AS. SELECT column_name AS 'Alias' FROM table_name; ...
AVG() SELECT AVG(column_name) ...
BETWEEN. SELECT column_name(s) ...
CASE. SELECT column_name, ...
COUNT() SELECT COUNT(column_name) ...
CREATE TABLE. CREATE TABLE table_name (
mark me as brainlist