Question 1

The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: Click Here)

0

SQL Anonymous 55 years 0 Answers 658 views

Question 2

Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: Click Here)

in progress 0

SQL Anonymous 55 years 0 Answers 540 views

Question 3

Write a Query to Find the account with the highest number of followers in every country. Explain the approach?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: Click Here)

in progress 0

SQL Anonymous 55 years 0 Answers 623 views

Question 4

Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: Click Here)

0

SQL Anonymous 55 years 0 Answers 559 views

Question 5

Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: https://drive.google.com/file/d/12_SVXe7VO-53DJ14IJZilLfpiNWTbUUW/view?usp=sharing)

in progress 0

SQL Anonymous 55 years 0 Answers 721 views

Question 6

Suppose there is a theatre and you need to write a sql program where your code can provide options to a customer in a particular row if the person wants adjacent seat with x number of people

Question

There is one table with three columns i.e. column name, seat number and occupied(binary) Write a program for the above mentioned condition

0

SQL 55 years 0 Answers 896 views Grand Master

Question 7

Longest Streak in SQL

Question

Table - Incidents Column Date_of_incidence , incidents Get the start date with the longest period without any incidence

2

SQL 55 years 0 Answers 1142 views Grand Master

Question 8

Getting the order of screen names

Question

Q: We have a product. It’s screen and event data is as below: Screen Name Event Name Timestamp A 1 ...

1

SQL 55 years 0 Answers 613 views Newbie

Question 9

Transposing Rows data into Columnar form

Question

Q: We have CUSTOMER table having columns as Customer_Name, Merchant_name (Amazon, Flipkart, Myntra etc.) and Transaction_value (Purchase value for each of these merchants). Write a query to Transpose this into Customer Name, Merchant Names as individual columns and their transaction ...

in progress 0

SQL 55 years 0 Answers 660 views Newbie

Question 10

Adding the missing months for customers

Question

Q: We have a CUSTOMER table having columns as Cust_ID, Month, Sales_value. Write a SQL query to add the missing months for each customer and to have sales value = 0, corresponding to those missing months which are added

in progress 2

SQL 55 years 0 Answers 626 views Newbie

Register Now

Login

Lost Password

Category : SQL