I am new to sql and am trying to complete my first project
I have this query
SELECT Nationality, SUM(Kill) AS total_kills_by_region
FROM vct2
WHERE Nationality = ‘United States’;
It selects the sum of total kills in a valorant championship where the player’s nationality is the united states. All of the nationality types are # Nationality
‘Argentina’
‘Belgium’
‘Brazil’
‘Canada’
‘Chile’
‘Finland’
‘France’
‘International’
‘Kazakhstan’
‘Latvia’
‘South Korea’
‘Sweeden’
‘Turkey’
‘Ukraine’
‘United Kingdom’
‘United States’
Do I have to just copy and paste this query over and over again to get the results for all of these?
I plan to compile a map in tableau with the results.

Table Name: config

The query brings back the correct information in each column but i want to limit the output to only include the employee records with the lowest number in the ‘Date Difference’ column for each.

I keep getting errors in my code saying:

I have a user that I have already permission to be able to CREATE a temporary table, however when she tries to load a csv file into that temporary table, we’re getting a restricted access error for loading. In general, she is not permissioned to load a csv file into any real tables. I only want her to be able to load data into any temporary table she wants. How can I achieve this?

enter image description hereI am facing an error message ( image attached below) in MySQL workbench(latest version) . While loading the csv file into the database this error prompts up and stop the data importing process. I have tried finding the solution to this bug , but not satisfactory response came from there .