'Database SQLite3 random numbers came out
Good evening. This is my second post on random numbers. I created a database with 9 columns and 605 rows (database created with SQLite3). On column 3, 4, 5, 6, 7 there are numbers ranging from 1 to 90 random. Now I would like to create a query that tells me on each line how many times there is not a number. When the number is there, I have to put zero and then start counting again how many times a number is not there. The table is divided into 11 lines: Bari, Cagliari etc. For each city I have to count how many times there is no number. I await your response. Thanks.
Link image
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|