He has hosted My Room, for the Royal Children’s Hospital, raising over 0,000 on the night at Crown Casino.
He’s also fronted Purple Nights, for the Allanah and Madeline Foundation and the Parkinson’s Victoria Gala Dinner.
Then use CASE to examine the row numbers and generate columns for the first three records: SELECT r.employee ID , MAX( CASE WHEN r. Employee Rating ELSE 0 END ) AS Last Rating , MAX( CASE WHEN r. Employee Rating ELSE 0 END ) AS Second Last Rating , MAX( CASE WHEN r. Employee Rating ELSE 0 END ) AS Third Last Rating FROM ( SELECT m.employee ID , m.employee Rating , Rating Date , ( SELECT COUNT(*) FROM your Table cnt WHERE cnt.employee ID = m.employee ID AND Rating Date A last option is to use Cold Fusion.
And this doesn’t even mention the Commonwealth Games, the Grand Prix or watching the Australian Netball Diamonds.Pete was also the host of the cult hit show on Channel 9 – a summer TV hit that attracted more than 900,000 viewers per episode!He is also presenting “On Display” for Channel 9, showcasing the very best of home design and the best urban developments.Maybe you saw him as the MC for Melbourne Victory, or at a Melbourne Vixen game?Or in years gone by, the host for the Melbourne Storm??