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_name_56 (no_6 VARCHAR, no_10 VARCHAR, no_8 VARCHAR)
  ### Question:
  What is the No. 6 of the person with a No. 10 of Joshua and a No. 8 of Andrew?
  ### Answer:
  SELECT no_6 FROM table_name_56 WHERE no_10 = "joshua" AND no_8 = "andrew"