Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.80K
1 Posted Topic
[QUOTE=skivranger;1134409][CODE]SELECT A.COUNTRY,AVG((0.5*(BORE*BORE*BORE)) )AS SUMMA FROM ( SELECT DBO.CLASSES.COUNTRY ,dbo.CLASSES.BORE FROM DBO.CLASSES INNER JOIN DBO.ships ON DBO.CLASSES.CLASS=DBO.ships.CLASS UNION ALL SELECT DBO.CLASSES.COUNTRY ,dbo.CLASSES.BORE--,DBO.OUTCOMES.ship FROM DBO.OUTCOMES LEFT JOIN DBO.ships ON DBO.OUTCOMES.ship=DBO.ships.name INNER JOIN DBO.CLASSES ON DBO.CLASSES.class= DBO.OUTCOMES.ship WHERE DBO.ships.CLASS IS NULL AND NOT DBO.CLASSES.COUNTRY IS NULL group by DBO.CLASSES.COUNTRY ,dbo.CLASSES.BORE,DBO.OUTCOMES.ship )A GROUP BY …
The End.