Question

Swati created a database of her classmates and entered 30 records in it. The teacher has asked her to show the data of those students who have scored less than 50% marks. Suggest her the method to apply this criteria.​

Answer 1

Answer:

She must follow this:-

SELECT <NAME> FROM <TABLENAME> WHERE <PERCENTAGE_MARKS> <50;

Explanation:

The query in sql will be

SELECT <NAME> FROM <TABLENAME> WHERE <PERCENTAGE_MARKS> <50;

Here NAME is the column name containing all students name. TABLENAME is the table which is stored in database having NAME and PERCENTAGE_MARKS as attributes or columns. PERCENTAGE_MARKS is a column having percentage of all 30 students in the database.

Answer 2

Answer:

name is the column name containing all students name. table name is the table in which is stored in database having name and percentage marks as attributes. percentage marks is a column having percentage of all 30 students in the database.