text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_11964047_5 (record VARCHAR, streak VARCHAR, leading_scorer VARCHAR)
  ### Question:
  what is the total number of record where streak is l2 and leading scorer is roy : 23
  ### Answer:
  SELECT COUNT(record) FROM table_11964047_5 WHERE streak = "L2" AND leading_scorer = "Roy : 23"