Dev.D

* ProblemIf the customer's preferred delivery date is the same as the order date, then the order is called immediate; otherwise, it is called scheduled.The first order of a customer is the order with the earliest order date that the customer made. It is guaranteed that a customer has precisely one first order.Write a solution to find the percentage of immediate orders in the first orders of all ..

* ProbelmWrite an SQL query to find for each month and country, the number of transactions and their total amount, the number of approved transactions and their total amount.Return the result table in any order. * Solution# Write your MySQL query statement below Select DATE_FORMAT(trans_date, '%Y-%m') AS month,             country,             COUNT(*) AS trans_count,             sum(state='appr..

* ProblemWe define query quality as:The average of the ratio between query rating and its position.We also define poor query percentage as:The percentage of all queries with rating less than 3.Write a solution to find each query_name, the quality and poor_query_percentage.Both quality and poor_query_percentage should be rounded to 2 decimal places.Return the result table in any order.The result ..

* Problem Write a solution to find the percentage of the users registered in each contest rounded to two decimals.Return the result table ordered by percentage in descending order. In case of a tie, order it by contest_id in ascending order. Explanation: All the users registered in contests 208, 209, and 210. The percentage is 100% and we sort them in the answer table by contest_id in ascending ..

* ProblemWrite an SQL query that reports the average experience years of all the employees for each project, rounded to 2 digits.Return the result table in any ordeExplanation: The average experience years for the first project is (3 + 2 + 1) / 3 = 2.00 and for the second project is (3 + 2) / 2 = 2.50 * Solution # Write your MySQL query statement below select  a.project_id project_id,           ..