Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
select goalsScored = ps.scored, numAssists = isNull( ps2.assists1, 0 ) + isNull( ps3.assists2, 0 ), playerName = p.firstName + ' ' + p.lastName from tPlayers_x_GamesPlayed pgp inner join tPlayers p on p.playerID = pgp.playerID left outer join (select scoredBy,COUNT(*) as scored from tPlayerStats group by scoredBy ) as ps on ps.scoredBy = pgp.playerID left outer join (select assist1,COUNT(*) as assists1 from tPlayerStats group by assist1 ) as ps2 on ps2.assist1 = pgp.playerID left outer join ( select assist2,COUNT(*) as assists2 from tPlayerStats group by assist2 ) as ps3 on ps3.assist2 = pgp.playerID where pgp.gameID = 102 and pgp.teamID = 100 and ( isNull( p.position1, '' ) <> 'Goalie' and isNull( p.position2, '' ) <> 'Goalie' and isNull( p.position3, '' ) <> 'Goalie' ) group by p.firstName, p.lastName, ps.scored, ps2.assists1, ps3.assists2 order by p.lastname,p.firstname;
|SQL 2012 - Database Move to new server - Unknown SQL User password||10||31|
|vsphere6 installation and deployment type and other questions||2||39|
|Isolation level in SQL server||3||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!