Create Schema demo; CREATE TABLE demo.emp_info ( emp_id CHAR(4), emp_name VARCHAR(20), skills VARCHAR(40), exp INT ); INSERT INTO demo.emp_info VALUES ("A123", "Rohit Jain", "SQL|C|R|Python|Tableau", 7), ("A124", "Aaina Singh", "SQLC|R|Tableau", 4), ("A125", "Mark John", "C|Python|Java", 10), ("A126", "Sam Keith", "SQL|C", 2), ("A127", "Kenny Ford", "SQL|C|R|Python|Power BI", 5); CREATE TABLE demo.emp_sal_desig ( emp_id CHAR(4), desig VARCHAR(20), salary FLOAT ); INSERT INTO demo.emp_sal_desig VALUES ("A123", "L3", 4500), ("A126", "L1", 2500), ("A121", "L2", 3500), ("A122", "L5", 9500);
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter