SQL Interview Question #7 | Asked in LTIMindtree | Hindi | Praveen Kumar

Topic Learnt:
1- CASES in SQL
=====================================================================
Copy this query to mysql workbench:
CREATE DATABASE IQ_DB;
USE IQ_DB;
DROP DATABASE IQ_DB;
CREATE TABLE user_view (
userid int,
date_ DATE,
page_visited VARCHAR(20)
);
INSERT INTO user_view (userid, date_, page_visited) VALUES
(1,"2021-10-28","home"),
(1,"2021-10-29","payment"),
(1,"2021-10-30","management"),
(2,"2021-10-28","home"),
(1,"2021-10-28","home");
SELECT * FROM user_view;
DESCRIBE user_view;
=====================================================================
Keep Learning and Keep Shinning!!
Like, Share and Subscribe!!
#ibm #interview #interviews #interviewquestions #interviewer #sql #mysql #sqldeveloper