SQL Challenge Day #34 In Telugu | SQL Interview Question తెలుగులో
Hi ఫ్రెండ్స్ ఈ వీడియోలో SQL Challenge Day #34 ని ఎలా solve చెయాలో తెలుగులో Explain చేసాము. By Excel Telugu Videos (Srinivas Reddy).
This Short is About SQL Challenge Day #33 in Telugu for SQL Developers, Data Analyst and Business Analyst. By Srinivas Reddy Excel Telugu Videos
SQL Interview Question and SQL Challenges in Telugu
Requirement:
// Count the number of Sales Transactions for each Customer
Query:
/* Find the Names of the Customer that are not referred by the Customer with ID = 2 */
CREATE TABLE customer (
id INT PRIMARY KEY,
name VARCHAR(50),
referee_id INT,
FOREIGN KEY (referee_id) REFERENCES customer(id)
);
INSERT INTO customer (id, name, referee_id) VALUES
(1, 'Will', NULL),
(2, 'Jane', NULL),
(3, 'Alex', 2),
(4, 'Bill', NULL),
(5, 'Zack', 1),
(6, 'Mark', 2);
SELECT *FROM CUSTOMER
go
SELECT NAME FROM CUSTOMER
WHERE ID NOT IN
(
SELECT ID FROM CUSTOMER
WHERE referee_id = 2
)
#sql #excel #shorts #telugu #excelteluguvideos #mysql #sqltelugu
Please Follow us on Instagram: / excelteluguvideos
Telegram: https://t.me/EXCELTELUGUVIDEOS