우사미 코딩

A, E, I, O, U로 시작하는 CITY를 중복없이 SELECT하기 SELECT DISTINCT CITY FROM STATION WHERE SUBSTRING(CITY,1,1) in('A','E','I','O','U'); SUBSTRING(string, start, length)

Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows: For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru', there are 2 different city names: 'New York' and 'Bengalaru'. The query returns , because . 이 이미지에는 데이터베이스의 'STATION' 테이..

Weather Observation Station 3 Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer. SELECT CITY FROM STATION WHERE MOD(ID, 2) = 0 GROUP BY CITY;

https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/?envType=study-plan-v2&envId=top-sql-50 LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com - SQL Schecma Create table If Not Exists Visits(vi..

이거슨 leet code의 1378 문제 - SQL Schema Create table If Not Exists Employees (id int, name varchar(20)) Create table If Not Exists EmployeeUNI (id int, unique_id int) Truncate table Employees insert into Employees (id, name) values ('1', 'Alice') insert into Employees (id, name) values ('7', 'Bob') insert into Employees (id, name) values ('11', 'Meir') insert into Employees (id, name) values ('90', ..