归档 2017年5月9日

[LeetCode]Count Student Number in Departments

题目描述:

LeetCode 580. Count Student Number in Departments

A university uses 2 data tables, student and department, to store data about its students and the departments associated with each major.

Write a query to print the respective department name and ...

继续阅读

[LeetCode]Get Highest Answer Rate Question

题目描述:

LeetCode 578. Get Highest Answer Rate Question

Get the highest answer rate question from a table survey_log with these columns: uid, action, question_id, answer_id, q_num, timestamp.

uid means user id; action has these kind of values: "show", "answer", "skip" ...

继续阅读

昨天

明天

归档