SQL Problem Asked in GOOGLE | SQL Interview Questions | Cracking FAANG 🔥🔥🔥

In this video we will discuss SQL problem asked in google data science interview.

If you wanna make your career in Data Science domain, then check our course now. We provide hands-on practical learning experience to our learners with 1-1 Live Doubt Clearance Support over Chat everyday and also you will learn Job Hunting Hacks. You will get projects and case studies that you can add in your resume and a lot more features are there inside this course. Check Now!

➡️ Data Science & Analytics Placement Assurance Program

➡️ Data Engineering Placement Assurance Program

➡️ Data Science Combo with Growth Hacking

➡️ Data Analytics/ Business Analytics Combo with Growth Hacking

Our Social Media Channels

Stay Safe and Keep Learning

[CloudyML]

SCRIPT:



CREATE TABLE search_category(
country varchar(20),
category varchar(20),
num_search int,
invalid_result_pct decimal (4, 2)
);

INSERT INTO search_category (country, category, num_search, invalid_result_pct)
VALUES
('UK', 'Home', 25000, 2.00),
('UK', 'Tax', 98000, 1.00),
('UK', 'Travel', 3.25),
('UK', 'Movies', null, null);

select * from search_category;

1----

select country, num_search, invalid_result_pct,
case when invalid_result_pct is not null
then num_search
else null
end as num_search_2,
round ((num_search*invalid_result_pct)/100.0, 0) as invalid_search
from search_category
where num_search is not null
and invalid_result_pct is not null;

with invalid_results
as (
select country, num_search, invalid_result_pct,
case when invalid_result_pct is not null
then num_search
else null
end as num_search_2,
round ((num_search*invalid_result_pct)/100.0, 0) as invalid_search
from search_category
where num_search is not null
and invalid_result_pct is not null
)
select country, sum(num_search_2) as total_search,
* 100.0, 2) as invalid_result_pct
from invalid_results
group by country
order by country;

---m2--

select country,
sum(num_search) as total_search,
round(sum(num_search * invalid_result_pct) / sum(num_search), 2) as invalid_result_pct
from search_category
where num_search is not null and invalid_result_pct is not null
group by country
order by country

[harshi]

select country, total_search, invalidsearch/total_search*100 from(
select country, sum(num_search) as total_search, round(sum(num_search*invalid_result_pct)/100, 2) as invalidsearch from google
group by country) as a;
it can also be done like this

[dwaipayansaha]

My solution
select country, sum(num_search) total_searches,
round(sum(num_search * invalid_result_pct)/sum(num_search), 2) tot_pct_invalid_search from search_category
where num_search or invalid_result_pct is not null
group by country

[meghnarijhwani]

Hey Team CloudyML Could you please share the same doc