Answer the question
In order to leave comments, you need to log in
How to force integer when forming a view in SQLite?
Hello. There is a database with voting data.
Separate tables with: 1) projects 2) project authors 3) categories 4) votes by day - the last one is our main work data:
SELECT
project_votes.project_number AS "Номер проєкту",
CAST(project_votes."15.12.2021"-project_votes."13.12.2021" AS INTEGER) AS "Четвер",
project_votes."17.12.2021" - project_votes."15.12.2021" AS "Пятниця",
project_votes."18.12.2021" - project_votes."17.12.2021" AS "Субота",
project_votes."19.12.2021" - project_votes."18.12.2021" AS "Неділя",
project_votes."20.12.2021" - project_votes."19.12.2021" AS "Понеділок",
project_votes."21.12.2021" - project_votes."20.12.2021" AS "Вівторок",
project_votes."21.12.2021" AS "Станом на зараз",
projects.content_short AS "Короткий опис"
FROM
project_votes
INNER JOIN projects ON project_votes.project_number = projects.project_number
ORDER BY
project_votes."21.12.2021" DESC
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question