Condition Filtering
-
[SQL] 조건문을 활용한 특정 칼럼 조회하기Data Analysis/SQL 2023. 12. 15. 22:23
Table of Contents Question Answer Reference Question Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA. The CITY table is described as follows: Answer Question quest us how to query the NAME field for all America cities. And it tell us they have populations larger than 120000. So, We use "Condition Filtering". M..
-
[SQL] 조건문을 활용한 모든 데이터 조회하기Data Analysis/SQL 2023. 12. 10. 23:14
Table of Contents Question Answer Reference Question Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA. The CITY table is described as follows: Answer Question quest us how to query all columns for all America cities. And it tell us they have populations larger than 100000. So, We use "Condition Filtering". SELECT ..