Exercise #59 (recycling firm) | Interactive tutorial on SQL

	Common mistakes in solving SELECT statement exercises Database «Recycled materials company» Exercise #59
	Calculate the remainder at each outlet for the database with accounts drawn not more than once a day.Result set: point, remainder. Solution 2.2.1 Console Execute SELECT ss.point, ss.inc - dd.out FROM (SELECT i.point, SUM(inc) AS inc FROM Income_o i GROUP BY i.point ) AS ss, (SELECT o.point, SUM(out) AS out FROM Outcome_o o GROUP BY o.point ) AS dd WHERE ss.point = dd.point; SELECT ss.point, ss.inc - dd.out FROM (SELECT i.point, SUM(inc) AS inc FROM Income_o i GROUP BY i.point ) AS ss, (SELECT o.point, SUM(out) AS out FROM Outcome_o o GROUP BY o.point ) AS dd WHERE ss.point = dd.point; Scheme In the FROM clause in the each subqueries it is calculated the summa of cash income and outcome in each reception point. These subqueries are joined by the equal numbers of reception points, which allows line by line to calculate the cash balance in each point:ss.inc dd.out. It would seem that everything is correct; however, the decision 2.2.1 contains a bug. Try to find it. T&S To solve the problem on SQL-EX.RU mistakes subquery GROUP BY exercise 59

SQL Problems and solutions