목록leetcode (23)

HAZEL

[SQL : Leetcode] LEFT JOIN 문

1. 183. Customers Who Never Order >> 문제 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. Table: Customers. +----+-------+ | Id | Name | +----+-------+ | 1 | Joe | | 2 | Henry | | 3 | Sam | | 4 | Max | +----+-------+ Table: Orders. +----+------------+ | Id | CustomerId | +----+------------+ | 1 ..
DATA ANALYSIS/SQL 2021. 2. 13. 00:31
[SQL : HackerRank/Leetcode] INNER JOIN

1. African Cities >> 문제 Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: >> 문제 푼 코드 select city.NAME from city INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'Africa' www.hackerrank.c..
DATA ANALYSIS/SQL 2021. 2. 12. 16:44
[SQL : HackerRank/Leetcode] CASE 문

1. Type of Triangle >> 문제 Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table: Equilateral: It's a triangle with sides of equal length. Isosceles: It's a triangle with sides of equal length. Scalene: It's a triangle with sides of differing lengths. Not A Triangle: The given valu..
DATA ANALYSIS/SQL 2021. 2. 8. 04:39
이전 Prev 1 2 3 Next 다음