My table has the following columns: A boolean,B integer,C varchar(40)
I want to get a count of the true and false values in A for each combination of B and C, and the percentage of true values. For example, if the table has the following values:
A B C
true 35 bob
false 35 bob...
Ok, this gives a result of:
Product Store Sum
Pen Bookstore 1
Pen Supermarket 1
Paper Drugstore 1
Paper Bookstore 1
etc., but the problem is that it doesn't display zero values for Products that don't appear in a particular type of Store, and...
Hi, I'm posting in General because I didn't see a specific forum for SQLite. Here's my question:
I am having difficulty using SQLite. I have a table, let's say it's called Inventory and its fields are Product and Store, like this:
Product+Store
---------|---------
Pen | Bookstore
Soda...
In table UserInfo, I have three fields: Users, Requests, and Approvals. For each user, I want to find the percentage of requests that are approved. Here is some sample data:
User|Request|Approval
----+---------+--------
A Y Y
B N N
C Y N
A N...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.