Files

C++
Golang
Java
MySQL
- active-businesses.sql
- active-users.sql
- activity-participants.sql
- actors-and-directors-who-cooperated-at-least-three-times.sql
- ads-performance.sql
- all-people-report-to-the-given-manager.sql
- all-valid-triplets-that-can-represent-a-country.sql
- apples-oranges.sql
- article-views-i.sql
- article-views-ii.sql
- average-salary-departments-vs-company.sql
- average-selling-price.sql
- average-time-of-process-per-machine.sql
- bank-account-summary-ii.sql
- bank-account-summary.sql
- big-countries.sql
- biggest-single-number.sql
- calculate-salaries.sql
- capital-gainloss.sql
- classes-more-than-5-students.sql
- combine-two-tables.sql
- consecutive-available-seats.sql
- consecutive-numbers.sql
- count-student-number-in-department.sql
- countries-you-can-safely-invest-in.sql
- create-a-session-bar-chart.sql
- customer-order-frequency.sql
- customer-placing-the-largest-number-of-orders.sql
- customer-who-visited-but-did-not-make-any-transactions.sql
- customers-who-bought-all-products.sql
- customers-who-bought-products-a-and-b-but-not-c.sql
- customers-who-never-order.sql
- delete-duplicate-emails.sql
- department-highest-salary.sql
- department-top-three-salaries.sql
- duplicate-emails.sql
- employee-bonus.sql
- employees-earning-more-than-their-managers.sql
- evaluate-boolean-expression.sql
- exchange-seats.sql
- find-cumulative-salary-of-an-employee.sql
- find-customer-referee.sql
- find-median-given-frequency-of-numbers.sql
- find-the-missing-ids.sql
- find-the-quiet-students-in-all-exams.sql
- find-the-start-and-end-number-of-continuous-ranges.sql
- find-the-team-size.sql
- find-users-with-valid-e-mails.sql
- fix-product-name-format.sql
- friend-requests-i-overall-acceptance-rate.sql
- friend-requests-ii-who-has-the-most-friends.sql
- friendly-movies-streamed-last-month.sql
- game-play-analysis-i.sql
- game-play-analysis-ii.sql
- game-play-analysis-iii.sql
- game-play-analysis-iv.sql
- game-play-analysis-v.sql
- get-highest-answer-rate-question.sql
- get-the-second-most-recent-activity.sql
- group-sold-products-by-the-date.sql
- highest-grade-for-each-student.sql
- hopper-company-queries-i.sql
- hopper-company-queries-ii.sql
- hopper-company-queries-iii.sql
- human-traffic-of-stadium.sql
- immediate-food-delivery-i.sql
- immediate-food-delivery-ii.sql
- investments-in-2016.sql
- last-person-to-fit-in-the-elevator.sql
- list-the-products-ordered-in-a-period.sql
- managers-with-at-least-5-direct-reports.sql
- market-analysis-i.sql
- market-analysis-ii.sql
- median-employee-salary.sql
- monthly-transactions-i.sql
- monthly-transactions-ii.sql
- movie-rating.sql
- new-users-daily-count.sql
- not-boring-movies.sql
- npv-queries.sql
- nth-highest-salary.sql
- number-of-comments-per-post.sql
- number-of-transactions-per-visit.sql
- number-of-trusted-contacts-of-a-customer.sql
- page-recommendations.sql
- patients-with-a-condition.sql
- percentage-of-users-attended-a-contest.sql
- product-price-at-a-given-date.sql
- product-sales-analysis-i.sql
- product-sales-analysis-ii.sql
- product-sales-analysis-iii.sql
- project-employees-i.sql
- project-employees-ii.sql
- project-employees-iii.sql
- queries-quality-and-percentage.sql
- rank-scores.sql
- rectangles-area.sql
- reformat-department-table.sql
- replace-employee-id-with-the-unique-identifier.sql
- report-contiguous-dates.sql
- reported-posts-ii.sql
- reported-posts.sql
- restaurant-growth.sql
- rising-temperature.sql
- running-total-for-different-genders.sql
- sales-analysis-i.sql
- sales-analysis-ii.sql
- sales-analysis-iii.sql
- sales-by-day-of-the-week.sql
- sales-person.sql
- second-degree-follower.sql
- second-highest-salary.sql
- sellers-with-no-sales.sql
- shortest-distance-in-a-line.sql
- shortest-distance-in-a-plane.sql
- students-and-examinations.sql
- students-report-by-geography.sql
- students-with-invalid-departments.sql
- swap-salary.sql
- team-scores-in-football-tournament.sql
- the-most-frequently-ordered-products-for-each-customer.sql
- the-most-recent-orders-for-each-product.sql
- the-most-recent-three-orders.sql
- top-travellers.sql
- total-sales-amount-by-year.sql
- tournament-winners.sql
- tree-node.sql
- triangle-judgement.sql
- trips-and-users.sql
- unique-orders-and-customers-per-month.sql
- unpopular-books.sql
- user-activity-for-the-past-30-days-i.sql
- user-activity-for-the-past-30-days-ii.sql
- user-purchase-platform.sql
- warehouse-manager.sql
- weather-type-in-each-country.sql
- winning-candidate.sql
Python
Shell
.travis.yml
LICENSE.md
README.md

user-activity-for-the-past-30-days-i.sql

Create user-activity-for-the-past-30-days-i.sql

Aug 2, 2019

08711de · Aug 2, 2019