学习笔记
文章平均质量分 88
项目实战作业
仙本娜
健康信息学数据媛
展开
-
【SQLZOO学习打卡】Tutorial:Section D
Part 8. Using NULL原创 2022-05-10 23:00:01 · 153 阅读 · 0 评论 -
【SQLZOO学习打卡】Tutorial:Section C
Part 6. The JOIN Operation@ Game table:@ Goal table:@ Eteam table:1. JOIN: use data from two or more tablesYou can combine the two steps into a single query with aJOIN.SELECT * FROM game JOIN goal ON (id=matchid)TheFRO...原创 2022-05-10 16:07:39 · 99 阅读 · 0 评论 -
【SQLZOO学习打卡】Tutorial:Section B
Part 4.SELECT within SELECT Tutorial@ Worldtable:(name, continent, area, population, gdp)# Using SELECT in SELECTThe result of a SELECT statement may be used as a value in another statement. put somename after the closing bracket as Alias Using...原创 2022-05-09 16:38:18 · 229 阅读 · 0 评论 -
【SQLZOO学习打卡】Tutorial:Section A
SQLZOO刷题笔记原创 2022-05-07 20:04:07 · 256 阅读 · 0 评论 -
【DatawhaleSQL学习打卡】Task06:决胜秋招Section C
Section C练习一:行转列按要求对比赛结果进行格式转换。1、创建比赛结果表row_to_coldrop table if exists row_to_col;create table row_to_col(cdate DATE, result varchar(32) not null);insert into row_to_col values(20210101,'胜');insert into row_to_col values(20210101,'负');ins原创 2022-03-28 16:53:36 · 1670 阅读 · 0 评论 -
【DatawhaleSQL学习打卡】Task06:决胜秋招Section B
Section B练习一:行转列按要求将A B C 三位小朋友期末考试成绩进行格式转换。1、创建学生成绩表student_scoredrop table if exists student_score;create table student_score(name varchar(4) not null, subject varchar(64) not null, score integer(4) not null, primary key(name,subject) );i原创 2022-03-28 16:21:45 · 820 阅读 · 0 评论 -
【DatawhaleSQL学习打卡】Task06:决胜秋招Section A
Section A练习一:各部门工资最高的员工(难度:中等)1、创建Employee表,包含所有员工信息,每个员工有其对应的Id, salary和department Id。CREATE DATABASE IF NOT EXISTS exercises;use exercises;drop table if exists Employee;create table Employee(Id CHAR(1) NOT NULL,Name VARCHAR(5) NOT NULL,S...原创 2022-03-28 12:34:39 · 247 阅读 · 0 评论