Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 14th, 2012  |  syntax: None  |  size: 0.83 KB  |  hits: 16  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. b select player_no from penalties where amount>100 group by player_no having count(player_no)>2 order by player_no asc
  2. c select player_no from players where joined_year between 2005 and 2007
  3. d select player_no, concat(first_name, ' ', last_name) from players where position('_', last_name)>0
  4. e select player_no, concat(first_name, ' ', last_name) from players where len(last_name)>2
  5. f select count(payment_no), max(amount) from penalties
  6. g select player_no, avg(amount), count(payment_no) from penalties group by player_no having count(payment_no)>1
  7. h
  8. i select player_no, count(payment_no) from penalties group  by player_no having sum(amount)>100
  9. j select player_no from committee_members where player_no not in (select player_no from penalties)
  10. k alter table players add column telephone_no int
  11. l alter table players drop column GENDER
create a new version of this paste RAW Paste Data