项目介绍

mdh266/SQL-Practice 是一个托管在 GitHub 上的开源项目,目前获得 398 个 Star、101 次 Fork。

仓库全名
mdh266/SQL-Practice
Star 数
398
Fork 数
101
未关闭 Issue
1

README 摘要

Practice SQL Scripts From Interview Prep Websites These are scripts that answer questions from leetcode , DataLemur , hackerank and sqlzoo . Links to questions and my answers are below! LeetCode Question | Answer | :| Employees earn more than their managers | Solution | Second highest salaries | Solution | Customers who never order | Solution | Duplicate Emails | Solution | Rising Temperatures | Solution |…

完整内容见 GitHub 原始 README 或本页 。

常见问题

如何获取 SQL-Practice 的源码?

可以直接克隆仓库:git clone https://github.com/mdh266/SQL-Practice.git,默认分支为 master;安装与运行步骤见仓库 README。

SQL-Practice 最近还在维护吗?

仓库最近一次更新为 2024年8月4日,当前有 1 个未关闭 Issue;Star 数为 398,可作为社区活跃度的参考。

关于

Solutions to Problems For SQL on Leetcode, Hackerrank & DataLemur

描述取自 GitHub 官方 API,中文内容由 GitRead 中文社区 编辑团队整理。

README

Practice SQL Scripts From Interview Prep Websites


These are scripts that answer questions from leetcode, DataLemur, hackerank and sqlzoo. Links to questions and my answers are below!

LeetCode


Question Answer
Employees earn more than their managers Solution
Second highest salaries Solution
Customers who never order Solution
Duplicate Emails Solution
Rising Temperatures Solution
Department Top Three Salaries Solution
N-th Highest Salary Solution
Department Highest Salary Solution
Monthly Transactions I Solution
Managers with at Least 5 Direct Reports Solution
Rank Scores Solution
Not Boring Movies Solution
Exchange Seats Solution
Consecutive Numbers Solution
Human Traffice Of Stadium Solution
Trips and Users Solution
Capital Gains/Loss Solution
Market Analysis I Solution
Tree Node Solution
Restaurant Growth Solution
Game Play Analysis I Solution
Game Play Analysis IV Solution
Investments In 2016 Solution
Friend Requests II: Who Has the Most Friends Solution
Odd And Even Transactions Solution
Confirmation Rate Solution

DataLemur


Question Answer
Laptop vs. Mobile Viewership Solution
Average Review Ratings Solution
Matching Skills Solution
Odd and Even Measurements Solution
Y-on-Y Growth Rate Solution
Page With No Likes Solution
Frequently Purchased Pairs Solution
Supercloud Customer Solution
Sending vs. Opening Snap Solution
User’s Third Transaction Solution
Repeated Payments Solution
Compressed Mode Solution
Signup Activation Rate Solution
Highest-Grossing Items Solution
Top 5 Artists Solution
International Call Percentage Solution
Tweets’ Rolling Average Solution
Top Three Salaries Solution
Histogram of Users and Purchases Solution

Hacker Rank


Question Answer
Japanese Cities Solution
Earnings of employees Solution
Weather Observation Station 8 Soluton
Weather Observation Station 9 Soluton
More Than 75 Marks Solution
The Pads Solution
Binary Search Tree 1 Solution

SQLZoo


Question Answer
Richer Than UK Solution
Bigger Than Every Country In Europe Solution
Neighbours of Argentina and Australia Solution
Teams that have coach Fernando Santos Solution
Busy years for John Travolta Solution

评论

暂无评论