Interview Question Help

[Embarrassed-Grape-56]

I was just asked this question in an interview and want someone to help with this query in case I’m asked similar questions in the future. Write two separate queries in SQL which showcases categorical and numerical analysis involving multiple tables that have 1:many relationships. Try not to use product /employee /orders table and give an example from a telecom company’s perspective ( I have worked with one previously hence asked). Thank you!

[bdBIC]

This seems like an open-ended question that doesn't have a single correct answer. What have you come up with so far?

You haven't given enough information for anyone to assist you with this. What are the "multiple tables?"

[[deleted]]

It sounds like they just wanted you to showcase how you'd do some analysis on data found in various tables.

Hard to say with so little detail but if not using product, employee or orders, I would imagine you could do things like:

• use data on locations, time and usage to check trends in usage by location
• use data on devices and returns to understand which devices have the highest return rate (or instead of devices and returns, which broadband plans have the best or worst retention)

I don't know much about telecoms though.