Search results for query: *

Thanks, that worked well!

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...

Yes, there is a table that lists all stores.

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...