MySQL/patients-with-a-condition.sql · yuhang2__2/LeetCode-Solutions - Gitee.com

6月21日 Gitee Talk | 模力方舟 AI 应用沙龙 · 青岛站开放报名，来聊聊 AI+ 应用的多场景落地实践~

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

文件

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-names-in-a-table.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

products-worth-over-invoices.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

bk3435_ble_app_merge_crc.bin

克隆/下载

patients-with-a-condition.sql 101 Bytes

一键复制编辑原始数据按行查看历史

提交于 5年前 . Create patients-with-a-condition.sql

# Time:  O(n)
# Space: O(n)

SELECT * 
FROM Patients AS p
WHERE p.conditions REGEXP '^DIAB1| DIAB1';

Loading...

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

1

https://gitee.com/yuhang2__2/LeetCode-Solutions.git

git@gitee.com:yuhang2__2/LeetCode-Solutions.git

yuhang2__2

LeetCode-Solutions

LeetCode-Solutions

master