Day Mysql Database Exercises two

1. Table Relationships

 

Note: When you create a table, the length and type of the field are set according to rationality.

2. Below: Start your Show

1. Check all personnel information

2. Only the person's name and age are queried

3. Find out who is 20 years of age

4. Inquiries about persons under 60 years of age

5. Find out who is over 50 years of age and who has a salary greater than 8000

6. Search for the person whose surname [Zhang] has

7. Find out which people belong to Wudang/Huashan/Songshan

8. Find out what people pay at 5000-8900

9. Check all personnel and ask for the order in reverse wage

10. Inquire who is the leader of the Fox rush

11. What is the maximum wage in the enquiry form?

12. What is the minimum wage in the enquiry form?

13. What is the average salary for all people?

14. Find out what the sum of all the people's wages is.

15. Query the number of people currently

16. Query the current martial arts which are the door faction

17. Find out who is the highest wage in the Wudang school

18. What is the average wage for each door?

19. Query the current martial arts in which the average wage is more than 8000 and in reverse order of wages

20. Query the 3rd data in the current people table to the 7th data

21. Find out which portals have no disciples

22. Query the Wudang faction who are the Disciples

23. Check the total wage of each door in reverse order

24. Delete the person with the highest salary, please keep the oldest one

25. Change the Wudang faction Zhang Sanfeng to transcript

26. Raise the wages of all the door-sending eldest brother by 10%, not including Alex.

27. See which people have a gated registered geographic location.

28. Check the location information of all personnel, the location information does not appear

29. What are the people in the gate faction in Hubei province?

30. In Shaanxi Province, the wages of the internal gate is less than 5000, the age of more than 20 years of age, the number of people, according to the primary key in reverse order

Day Mysql Database Exercises two