SQL CODE

1. List all the records in the student table.

2. List the student's name, surname and grade in the student table.

3. List the records in the student table whose gender is girl (K).

4. List the names of the classes in the students' table so that each class appears once.

5. List the students whose gender is Girl and Class is 10A in the student table.

6. List the name, surname and class of students in grade 10A or 10B on the student table.

7. List the student's name, surname and number in the student table as "school number".

8. Combine the student's name and surname in the student table and list them as name and surname.

9. List the students whose names begin with the letter 'A' in the student table.

10. Name and page number of books with 50 to 200 pages in the book table.

list.

11. List the students whose names are Fidan, smail and Leyla on the student table.

12. List the students whose names begin with A, D and K from the students in the student table.

13. Name, surname, class and name of boys with 9A or girls with 9B in the student table.

Please list the gender.

14. List males in class 10A or 10B.

15. In the student table, list the students whose year of birth is 1989.

16. List the female students whose student number is between 30 and 50.

17. List the students by name.

18. List students by name, and those with the same name by surname.

19. List the students in class 10A in descending order of school number.

20. List the top 10 entries in the students' table.

21. List the book with the highest number of pages.

22. List the youngest student in the student table.

23. List the books with the second letter N.

24. List students whose birthdate is null.

25. Find the average number of pages for all books.

26. List books whose number of pages is above the average page.

27. Show the number of students in the student table.

28. Find the number of students in each class.

29. Find the number of male and female students in each class.

30. Find out how many books of each genre there are.

student ogrenc ogro Estno ograd =stname ogrsoyad =stsurname cinsiyet Estgender dtarih =stbirthday sinif =stclass stpoint islem islemno ogmo od kitapno atarih vtarih =operation =operation_no =stno =book_no =a_date =v_date puan =author yazame=author_no yazarad =author_name yazarsoyad=author_surname book kitap kitapno book_no isbane isbno kitapadi book_name yazare author_name turno type_no sayasayisi pagenumber tur type tumnotype_no turadi type_name