Company: Phonepe ML engineer_19april
Difficulty: medium
You are given three tables: Clients , Investment_Products , and Investments , representing the details of an investment company. Task Write a query to find the clients who have inves ted in all available investment products. Sort the output alphabetically by the client's name. Table description Input format Table: Clients Name Type Description client_id Integer Represents the unique ID of the client client_name Varchar Re presents the name of the client client_type Varchar Re presents the type of cli ent date_of_birth Date Represents the dat e of birth of the client address Varchar Represents the client's address net_worth Float Represents the client's net worth Table: Investment_Products Name Type Description product_id Integer Represents the unique ID of the product product_name Varchar Represents the name of the product Interest_rate Float Represents the interest rate Table: Investments Name Type Description investment_id Integer Represents the uniqu e ID of the inve stment client_i