Business Analyst

Write an SQL query to retrieve the product ID along with the number of times each product has been reported. Include only products that have at least one report. The final result should be sorted by product ID in ascending order.

Write an SQL query to fetch the names of source_companies along with their return_on_investments, rounded to one decimal place. The results should be ordered in descending order based on the calculated return_on_investments, using the provided formula for ROI.

Write an SQL query to perform a RIGHT JOIN between two tables. The query should return all records from the right table and the matching records from the left table. If there is no match, the result should include NULL values for columns from the left table.

Write an SQL query to identify the highest-selling product in each category. Use the orders table (columns: product_id, order_id, quantity) and the products table (columns: product_id, name, category). The query should return the product name, category, and total quantity sold, showing only the top-selling product for each category.