Question

_/\_ Pranam¡
Happy Hug day
➡➡➡➡➡➡➡➡➡➡➡➡➡➡
Please answer this

☢Class 10th IT Chapter Ms access basic question

Plese solveヾ(｡>﹏<｡)ﾉﾞ✧*。​

Answer 1

$\huge\star{\green{\underline{\mathfrak{Answer :-}}}}$

i) SELECT*from "Teachers" where "Gender"='Female'

ii) SELECT*from "Teachers" where "Subject"='English'

iii) SELECT*from "Teachers" where "Level"='Middle School'

iv) SELECT*from "Teachers" where "Hobbies"='Listening Music'

v) SELECT*from "Teachers" where "Level"='Senior School' and "Subject"='Maths'

$\rule {200}2$

All the SQL statements used here are SELECT statement.

There can be three types of SELECT statement:-

• To display all records from students table.

Example :- SELECT * FROM "Teachers"

• To conditionally display.

Examples :- above. All the questions you asked had conditions. So, the answer is from this type.

• To display all records from the table in ascending order of ID.

Example :- SELECT * FROM "Teachers" order by "Tech_ID" ASC;

$\rule {200}2$

Get more information :-

https://brainly.in/question/15305017

https://brainly.in/question/15414003

$\rule {200}2$

Answer 2

$\huge{\fbox{\fbox{\bigstar{\mathfrak{\pink{SINGLE♡}}}}}}$

♡.

______________________

1. SELECT*from "Teachers" where "Gender"='Female'
2. SELECT*from "Teachers" where "Subject"='English'
3. SELECT*from "Teachers" where "Level"='Middle School'
4. SELECT*from "Teachers" where "Hobbies"='Listening Music'
5. SELECT*from "Teachers" where "Level"='Senior School' and "Subject"='Maths'

______________________