qq_45531594的博客

Create table If Not Exists Activities (sell_date date, product varchar(20))Truncate table Activitiesinsert into Activities (sell_date, product) values ('2020-05-30', 'Headphone')insert into Activities (sell_date, product) values ('2020-06-01', 'Pencil')

Create table If Not Exists Orders (order_id int, customer_id int, order_date date, item_id varchar(30), quantity int)Create table If Not Exists Items (item_id varchar(30), item_name varchar(30), item_category varchar(30))Truncate table Ordersinsert into

Create table If Not Exists Salaries (company_id int, employee_id int, employee_name varchar(13), salary int)Truncate table Salariesinsert into Salaries (company_id, employee_id, employee_name, salary) values ('1', '1', 'Tony', '2000')insert into Salarie

Create table If Not Exists Points (id int, x_value int, y_value int)Truncate table Pointsinsert into Points (id, x_value, y_value) values ('1', '2', '8')insert into Points (id, x_value, y_value) values ('2', '4', '7')insert into Points (id, x_value, y_

Create table If Not Exists Accounts (id int, name varchar(10))Create table If Not Exists Logins (id int, login_date date)Truncate table Accountsinsert into Accounts (id, name) values ('1', 'Winston')insert into Accounts (id, name) values ('7', 'Jonatha

Create table If Not Exists Sales (sale_date date, fruit ENUM('apples', 'oranges'), sold_num int)Truncate table Salesinsert into Sales (sale_date, fruit, sold_num) values ('2020-05-01', 'apples', '10')insert into Sales (sale_date, fruit, sold_num) values

Create Table If Not Exists Variables (name varchar(3), value int)Create Table If Not Exists Expressions (left_operand varchar(3), operator ENUM('>', '<', '='), right_operand varchar(3))Truncate table Variablesinsert into Variables (name, value) va

Create table If Not Exists Sessions (session_id int, duration int)Truncate table Sessionsinsert into Sessions (session_id, duration) values ('1', '30')insert into Sessions (session_id, duration) values ('2', '199')insert into Sessions (session_id, dura

Create table If Not Exists Student (student_id int, student_name varchar(30))Create table If Not Exists Exam (exam_id int, student_id int, score int)Truncate table Studentinsert into Student (student_id, student_name) values ('1', 'Daniel')insert into

Create table If Not Exists Customers (customer_id int, customer_name varchar(30))Create table If Not Exists Orders (order_id int, customer_id int, product_name varchar(30))Truncate table Customersinsert into Customers (customer_id, customer_name) values

Create Table If Not Exists Stocks (stock_name varchar(15), operation ENUM('Sell', 'Buy'), operation_day int, price int)Truncate table Stocksinsert into Stocks (stock_name, operation, operation_day, price) values ('Leetcode', 'Buy', '1', '1000')insert in

Create table If Not Exists UserActivity (username varchar(30), activity varchar(30), startDate date, endDate date)Truncate table UserActivityinsert into UserActivity (username, activity, startDate, endDate) values ('Alice', 'Travel', '2020-02-12', '2020-

Create table If Not Exists Customers (customer_id int, customer_name varchar(20), email varchar(30))Create table If Not Exists Contacts (user_id int, contact_name varchar(20), contact_email varchar(30))Create table If Not Exists Invoices (invoice_id int,

Create table If Not Exists Friends (id int, name varchar(30), activity varchar(30))Create table If Not Exists Activities (id int, name varchar(30))Truncate table Friendsinsert into Friends (id, name, activity) values ('1', 'Jonathan D.', 'Eating')inser

Create table If Not Exists Departments (id int, name varchar(30))Create table If Not Exists Students (id int, name varchar(30), department_id int)Truncate table Departmentsinsert into Departments (id, name) values ('1', 'Electrical Engineering')insert

Create table If Not Exists Movies (movie_id int, title varchar(30))Create table If Not Exists Users (user_id int, name varchar(30))Create table If Not Exists Movie_Rating (movie_id int, user_id int, rating int, created_at date)Truncate table Moviesinse

Create table If Not Exists Products (product_id int, product_name varchar(40), product_category varchar(40))Create table If Not Exists Orders (product_id int, order_date date, unit int)Truncate table Productsinsert into Products (product_id, product_nam

Create table If Not Exists Ads (ad_id int, user_id int, action ENUM('Clicked', 'Viewed', 'Ignored'))Truncate table Adsinsert into Ads (ad_id, user_id, action) values ('1', '1', 'Clicked')insert into Ads (ad_id, user_id, action) values ('2', '2', 'Clicke

Create table If Not Exists Logs (log_id int)Truncate table Logsinsert into Logs (log_id) values ('1')insert into Logs (log_id) values ('2')insert into Logs (log_id) values ('3')insert into Logs (log_id) values ('7')insert into Logs (log_id) values ('

Create table If Not Exists Customer (customer_id int, name varchar(20), visited_on date, amount int)Truncate table Customerinsert into Customer (customer_id, name, visited_on, amount) values ('1', 'Jhon', '2019-01-01', '100')insert into Customer (custom

Create table If Not Exists Scores (player_name varchar(20), gender varchar(1), day date, score_points int)Truncate table Scoresinsert into Scores (player_name, gender, day, score_points) values ('Aron', 'F', '2020-01-01', '17')insert into Scores (player

Create table If Not Exists Employee (employee_id int, team_id int)Truncate table Employeeinsert into Employee (employee_id, team_id) values ('1', '8')insert into Employee (employee_id, team_id) values ('2', '8')insert into Employee (employee_id, team_i

SQL 架构：Create table If Not Exists Countries (country_id int, country_name varchar(20))Create table If Not Exists Weather (country_id int, weather_state int, day date)Truncate table Countriesinsert into Countries (country_id, country_name) values ('2',

Create table If Not Exists Students (student_id int, student_name varchar(20))Create table If Not Exists Subjects (subject_name varchar(20))Create table If Not Exists Examinations (student_id int, subject_name varchar(20))Truncate table Studentsinsert

Create table If Not Exists Employees (employee_id int, employee_name varchar(30), manager_id int)Truncate table Employeesinsert into Employees (employee_id, employee_name, manager_id) values ('1', 'Boss', '1')insert into Employees (employee_id, employee

Create table If Not Exists Friendship (user1_id int, user2_id int)Create table If Not Exists Likes (user_id int, page_id int)Truncate table Friendshipinsert into Friendship (user1_id, user2_id) values ('1', '2')insert into Friendship (user1_id, user2_i

Create table If Not Exists Prices (product_id int, start_date date, end_date date, price int)Create table If Not Exists UnitsSold (product_id int, purchase_date date, units int)Truncate table Pricesinsert into Prices (product_id, start_date, end_date, p

Create table If Not Exists Submissions (sub_id int, parent_id int)Truncate table Submissionsinsert into Submissions (sub_id, parent_id) values ('1', 'None')insert into Submissions (sub_id, parent_id) values ('2', 'None')insert into Submissions (sub_id,

Create table If Not Exists Teams (team_id int, team_name varchar(30))Create table If Not Exists Matches (match_id int, host_team int, guest_team int, host_goals int, guest_goals int)Truncate table Teamsinsert into Teams (team_id, team_name) values ('10'

sql 架构Create table If Not Exists Queries (query_name varchar(30), result varchar(50), position int, rating int)Truncate table Queriesinsert into Queries (query_name, result, position, rating) values ('Dog', 'Golden Retriever', '1', '5')insert into Quer

1205 每月交易IIsql 架构；create table if not exists Transactions (id int, country varchar(4), state enum('approved', 'declined'), amount int, trans_date date)create table if not exists Chargebacks (trans_id int, trans_date date)Truncate table Transactionsins

1204sql 架构：Create table If Not Exists Queue (person_id int, person_name varchar(30), weight int, turn int)Truncate table Queueinsert into Queue (person_id, person_name, weight, turn) values ('5', 'George Washington', '250', '1')insert into Queue (pers

1193 每月的交易SQL 架构：create table if not exists Transactions (id int, country varchar(4), state enum('approved', 'declined'), amount int, trans_date date)Truncate table Transactionsinsert into Transactions (id, country, state, amount, trans_date) values ('

重新格式化部门表SQL 架构Create table If Not Exists Department (id int, revenue int, month varchar(5))Truncate table Departmentinsert into Department (id, revenue, month) values ('1', '8000', 'Jan')insert into Department (id, revenue, month) values ('2', '9000.

# Write your MySQL query statement below #错误写法，有点懵select round(sum(if(min_date=customer_pref_delivery_date,1,0)) /count(*)*100 ,2)as 'immediate_percentage'from (select distinct delivery_id,customer_id ,min(order_date) as 'min_date',customer_pref_del

select round(sum(if(order_date=customer_pref_delivery_date,1,0)) /count(*) *100,2)as 'immediate_percentage'from Delivery

select product_id,if(new_price>0,new_price,10) as ' price'FROM(select distinct product_id,10 as 'price'from Products) uleft join (SELECT product_id as 'nid',new_price FROM (select product_id, new_price,change_date, #对月份逆向排序 选择最大的.

# Write your MySQL query statement belowSELECT distinct user_id as 'seller_id',case when favorite_brand = item_brand then 'yes' else 'no'end as '2nd_item_fav_brand'FROM #用户卖出列表 (select user_id,favorite_brand #,b.order_date,b.seller_id,