Open kyohoonsim opened 1 year ago
1. [쿼리] select name from player where country = '한국' and age like '3%';
2. [쿼리] select * from player where age >= 30 and (company is null or country not in ('포르투갈'));
2-1 SELECT * FROM player WHERE age >= 30 AND country = '한국';
2-2 SELECT * FROM player WHERE age >=30 AND company IS NULL OR age >=30 AND country != '포르투갈';
2-1
2-2
2-1. SELECT * FROM player WHERE age LIKE '3%' AND country = '한국';
2-2. SELECT * FROM player WHERE age >=30 AND country != '포르투갈';
2-1.
정답 1) SELECT FROM player where age < 40 and age >= 30 AND country = '한국';
정답 2) select FROM player where age like '3%' and country = '한국';
2-2.
SELECT * FROM player where age >= 30 AND (company is null or country != '포르투갈');
2-1
2-2
2-1.
SELECT * FROM player WHERE age LIKE '3%' AND country='한국';
2-2.
SELECT * FROM player WHERE age >= 30 AND (company IS NULL OR country !='포르투갈');
2-1
2-2
2-1. SELECT * FROM player WHERE age >= 30 AND country = '한국';
2-2. SELECT * FROM player WHERE age >= 30 AND country != '포르투갈' OR country IS NULL;
2-1. [SQL 쿼리] [실행화면 캡쳐]
2-2. [SQL
select*from player where age like '3%' and country = '한국';
select*from player where age >=30 and country !='포르투갈';
2-1. SELECT name FROM player WHERE age LIKE '3%' AND country = '한국';
2-2. SELECT * FROM player WHERE age >=30 AND (company IS NULL OR country != '포르투갈');
2-1. SELECT name FROM player WHERE age LIKE '3%' AND country = '한국';
2-2. SELECT * FROM player WHERE age >= 30 AND (company is NULL OR country != '포르투갈');
3-1. select name from player where (age between 30 and 39) and country = '한국';
3-2. select * from player where age >= 30 and (company is null or country != '포르투갈');
2-1 SELECT * from player where age like '3%' and country = '한국';
2-2 SELECT * from player where age >= '30' and (company is null or country <> '포르투갈') ;
2-1.
age like '3%' and country = '한국';
2-2.
select * from player where age >=30 and (company is null or country <>'포르투갈');
2-1. SELECT name FROM player WHERE age LIKE '3%' AND country = '한국';
2-2. SELECT * FROM player WHERE age >=30 AND country != '포르투갈';
2-1. SELECT name FROM player WHERE age LIKE '3%' AND country = '한국';
2-2. SELECT * FROM player WHERE age >=30 AND country != '포르투갈';
2-1 Select name from player where age like ‘3%’ and country = ‘한국
2-2 Select * from player where age >=30 and (company is null or country <> ‘포르투갈’);
2-1
SELECT name FROM player WHERE age LIKE '3%' AND country = '한국';
2-2
SELECT * FROM player WHERE (company IS NULL OR country != '포르투갈') AND age >= 30;
2-1. [SQL 쿼리] [실행화면 캡쳐]
2-2. [SQL 쿼리] [실행화면 캡쳐]