Question

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

Answer 1

"The following query will be used to determine the answer;

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

Here, name will be the name of that specific column that will contain the name of the students, then there will table name in which the details of that specific name is given, then the percentage will have the marking details.

"

Answer 2

queries tab<query design<show table dialogue box appears<put criteria<and it done...........

voila

hope this helps☺☺