Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
PostreSQL: product table
--PostgreSQL 9.6 --'\\' is a delimiter --create a table CREATE TABLE product( product_id INT PRIMARY KEY NOT NULL, sku CHAR(50) NOT NULL, category VARCHAR(50) NOT NULL, date TIMESTAMP, price DECIMAL (10,2) ); INSERT INTO product (product_id, sku, category,date, price)VALUES (101, 'A113M1','Mascara', '2020-04-23', 23),(102,'A212M2', 'Mascara', '2020-02-12', 23),(103,'A221NP2','Nail Polish', '2020-03-07', 15), (104, 'A332NP2','Nail Polish', '2020-05-21', 15),(105 , 'A36LIPG','Lipgloss', '2020-07-15', 19); SELECT COUNT (*) AS "total records" FROM product;
run
|
edit
|
history
|
help
0
Assignment 1(SET A)
Leetcode 569. Median Employee Salary
Inner Join
SQL3
Ultima Clase
mandelbrot set
1225. Report Contiguous Dates
Select rows with no intersection on join table and check by date
Professional Networking Social Media Website SQL Analysis
Return IDs where there are exactly 3 occurrences