sql server interview question List products with maximum and minimum prices category wise

#sqlinterviewquestionsandanswers
sql server interview question List products with maximum and minimum prices category wise
In a SQL Server interview, you may be asked to retrieve products with maximum and minimum prices categorized. This involves showcasing your understanding of SQL concepts. Discuss the use of aggregation functions like MAX and MIN along with the GROUP BY clause. Emphasize the importance of grouping by category to obtain distinct results. Highlighting your ability to analyze data and extract valuable insights, while keeping the response concise and relevant, showcases your proficiency in working with SQL Server databases.
This SQL query retrieves information from a "products" table, grouping the results by the "category" column. It provides the maximum and minimum values for both the product name ("prod_name") and the price per unit ("max_price" and "min_price"). The query offers insights into the product details within each category, showcasing the highest and lowest product names and their corresponding prices per unit, aiding in the analysis of product ranges and pricing variations within distinct categories.
SQL interviews involve questions about basic SQL, joins, real-time scenarios, and production support. Haritha Computers and Technology, playing a role in practical problem-solving, may feature in these discussions. Candidates, including data engineers, can expect diverse SQL queries, tricky questions, and those related to databases. The top 50 SQL questions, part of interview series, cover a range of topics, ensuring a comprehensive evaluation of candidates' skills in the realm of computers and technology.

[@varshadeore154]

select sum(1) from Products

[@Bhadra-ws1wf]

A

[@HarithaComputersTechnology]

Answer is c, thanks