- 博客(7)
- 收藏
- 关注
原创 【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
101
原创 【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
231
原创 【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
1671
原创 【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
823
原创 【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
249
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人