Leetcode 178: Rank scores: My Solution
Free sample test question III.
with ranked as (select * ,dense_rank() over (order by score desc) as rn from scores)
select score, rn as 'Rank'from ranked order by score desc
Leetcode 185: Department Top Three Salaries: My Solution
Free sample test question II.
with combined as (select E.*, D.name as dep_name from employee E left join department D on E.departmentid = d.id ),
ranked as ( select * ,dense_rank() over (partition by dep_name order by salary desc) as rnfrom combined ) select dep_name as department, name as Employee, salary as Salary from…
Multiple tables in FROM
Inspired by Leetcode "Consecutive numbers" question
Let's take this example table first:
Results in simple 8 lines:
When I use the same table 3 times in the FROM clause:
512 rows..But why? 8*8*8 = 512.
So you need to narrow that combination down with the commented part:
Now we have the same table, 3 times, without the weired…
SEC Public Data in BigQuery
This is a partition table.. let's see what values can we partition by then:
Test:
How many companies:
SIC codes:
Getting all data:
