Write the SQlite query for find the age between 10 to 20 and show list of that name whose age between 10 to 20.

Q.46 Write the SQlite query for find the age between 10 to 20 and show list of that name whose age between 10 to 20.? Ans:-

• Database Name: MyCircle, Table Name: Friends
  |ID|Name  |Age|
  | 1 |Nitin    | 21 |
  | 2 |Kaka    | 22 |
  | 3 |Ganesh| 20 |
  | 4 |Sama    | 18 |
  | 5 |Pavan   | 16 |
  | 6 |Akash   | 10 |
  | 7 |Gopi      | 08 |
  | 8 |Rushi    | 04 |
  | 9 |Didi        | 04 |
• select * from Friends where Age between 10 and 20;
• output
  | 3 |Ganesh| 20 |
  | 4 |Sama    | 18 |
  | 5 |Pavan    | 16 |
  | 6 |Akash    | 10 |