ALTER TABLE customer_rewards 
    ALTER COLUMN count(rental_id) total_rentals
    bigint(21);

I'm trying to change name of the column: count(rental_id) to total_rentals
MySql recognizes count as a ...
        

            I'm using MariaDB and my records are all stored in UTC however I want to be able to find those records that are within the previous 12 calendar months based on my local timezone.
Here's the steps I ...
        

            Does anyone of domain specific languages (DSL) that facilitate data extraction and transformation as part of an Extract-Transform-Load (ETL) pipeline?
I'd like to extract data from a 3rd party SQL ...
        

            Let's say I have the following table:
date       | name  | value
----------------------------
2020-09-01 | name1 | 10
2020-09-02 | name1 | 9
2020-09-03 | name1 | 12
2020-09-04 | name1 | 11
2020-09-05 |...
        

            I'm trying to generate results that include customer information under certain criteria that is searched by date range. I feel like I am close however I would like to include accounts that apply all ...
        

            I have been working on this data to run multiple left join with a subquery to compute the revenue per payroll dollar per store
dt1_b <- sqldf("SELECT tEmp.Store, tStores.City, SUM(tPayroll....
        

            I have a table with 4 fields as follows

I want an Sql query to calculate a total salary for each month, where the result will be as follows
        

            I am trying to write a sql statement to control a report header selection of multiple database by user groups a user is assigned to. This is to limit the database selection security when running an ...
        

            I'm writing (as an exercise) a system where users get a list of vacations and can choose which vacations to "follow."
The UI for each vacation should convey two pieces of information:

How ...
        

            Table1
ID     Name     CourseID
1     Course 1   4002
2     Course 2   2342
3     Course 3   2410 

Table2
CourseID ProfName
4002     John
2342     bob 
2410     Bill
4002     Hannah
2342     Cyrus 

...
        

            I want to be able to support searching for a player
Let us say "Babe Ruth". I search for that player's name.
I want to return a query of only players that played ALL the same positions as ...
        

            I am trying to find a way to properly write a query to get the student answers for each question. I am not very good with SQL so I appreciate any help. This is for a student report I am building in ...
        

            # Users

| id    | name     | age  |
| ----- | -------- | ---- |
| 1     | Rand     | 25   |
| 2     | Mat      | 24   |
| 3     | Perrin   | 23   |

Given the above table I've been building queries ...
        

            3 different entities in one table I tried with and full outer join but I am confused
        

            I have a table schema in PostgreSQL which is used to monitor some device. Based on some condition, device enters into monitor phase and if it remains in that condition for next consecutive day, then ...