随笔分类 - Mysql
摘要：Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice ver
阅读全文
摘要：X city opened a new cinema, many people would like to go to this cinema. The cinema also gives out a poster indicating the movies’ ratings and descrip
阅读全文
摘要：There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For example, the tab
阅读全文
摘要：There is a table World A country is big if it has an area of bigger than 3 million square km or a population of more than 25 million. Write a SQL solu
阅读全文
摘要：Question: Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. + + +
阅读全文
摘要：Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything
阅读全文
摘要：Write a SQL query to find all duplicate emails in a table named Person. For example, your query should return the following for the above table: Selec
阅读全文
摘要：The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. + + + + + |
阅读全文
摘要：problem: Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ra
阅读全文
浙公网安备 33010602011771号