URI 2996 Solution

-

 URI 2996 - Package Delivery


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
SELECT year, sender, receiver
FROM packages AS p INNER JOIN (
	SELECT id_package, name AS sender 
	FROM packages 
	INNER JOIN users 
	ON id_user_sender = id 
	WHERE address <> 'Taiwan'
) AS sub1
ON sub1.id_package = p.id_package
INNER JOIN (
	SELECT id_package, name AS receiver 
	from packages 
	INNER JOIN users 
	ON id_user_receiver = id 
	WHERE address <> 'Taiwan'
) AS sub2
ON sub2.id_package = p.id_package
WHERE color = 'blue' OR year = 2015
ORDER BY year DESC, sender DESC
;

Comments

Post a Comment

Popular posts from this blog

URI 2994 Solution

-
URI 2994 - How much earn a Doctor?  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 SELECT d . name , ROUND (t . salary, 1 ) FROM doctors as d INNER JOIN ( SELECT id_doctor, SUM( (hours * 150 ) + ((hours* 150.0 * w . bonus) / 100.0 ) ) AS salary FROM work_shifts AS w INNER JOIN attendances AS a ON w . id = a . id_work_shift GROUP BY id_doctor ) AS t ON t . id_doctor = d . id ORDER BY t . salary desc ;
Read more