NIPA 서버 사용도중에 NVIDIA-SMI Driver가 실행되지 않는 문제 발생 NVIDIA-SMI has failed because it couldn't communicate with the NVIDIA driver. Make sure that the latest NVIDIA driver is installed and running해결책 : NVIDIA Driver를 다시 설치 apt --installed list | grep nvidia-driver -> 문제 : WARNING: apt does not have a stable CLI interface. Use with caution in scripts. -> 설치된 nvidia-driver를 확인하는 것으로 확인안해도 무방하고 아래의 명렁..
정형 데이터에서 범주형 변수를 처리하는 방법은 되게 까다롭습니다. 이번 포스팅에서는 제가 알고 있는 범주형 변수들에 대해서 설명하고 어떤 의미를 가지고있는지에 대해 작성해보도록 하겠습니다. 먼저 범주형 변수란 일종의 카테고리를 가지는 변수를 의미합니다. 예를들어 식물의 종도 일종의 카테고리가 되고 음식점의 종류 등 어떠한 집단을 의미하는 변수들을 의미합니다. 이러한 변수들은 컴퓨터가 인식할 수 없기에 인식할 수 있도록 인코딩을 해주는 작업이 필요합니다. 대표적으로 많이 알려진 인코딩 기법으로는 One-Hot Encoding, Label Encoding, Frequency Encoding, Target Encoding 등이 있습니다. 먼저, One-Hot Encoding은 일종의 변수를 1과 0으로 나누는..
Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. Q1. Query the following two values from the STATION table: The sum of all values inLAT_Nrounded to a scale ofdecimal places. The sum of all values inLONG_Wrounded to a scale ofdecimal places. Output Format Your results must be in the form: lat lon where lat is the sum..
We define an employee's total earnings to be their monthly salary x months worked, and themaximum total earningsto be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total earnings for all employees as well as the total number of employees who have maximum total earnings. Then print these values as 2space-separated integers. Input Format T..
Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's 0 key was broken until after completing the calculation. She wants your help finding the difference between her miscalculation (using salaries with any zeroes removed), and the actual average salary. Write a query calculating the amount of error (i.e.:act..
Input Format The CITY table is described as follows: Q1. Query the total population of all cities in CITY where Districtis California. SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = 'California' Q2. Query the average population of all cities in CITY where District is California. SELECT AVG(POPULATION) FROM CITY WHERE DISTRICT = 'California' Q3. Query the average population for..
Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respectivehacker_idandnameof hackers who achieved full scores formore than onechallenge. Order your output in descending order by the total number of challenges in which the hacker earned a full score. If more than one hacker received full scores in same number of chall..
You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Grades contains the following data: Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Ketty doesn't want the NAMES of those students who received a grade lower than 8. The report must be in descending order by grade -- i.e. higher grades are entered fir..
Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to the nearest integer. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: 풀이 SELECT O.CONTINENT, FLOOR(AVG(C.POPULATION)) FROM CITY AS C JOIN COU..
Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: 풀이 SELECT C.NAME FROM CITY AS C JOIN COUNTRY AS O ON C.COUNTRYCODE = O.CODE WHERE O.CONTINENT = 'Africa';
Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: 풀이 SELECT SUM(C.POPULATION) FROM CITY AS C JOIN COUNTRY AS O ON C.COUNTRYCODE = O.CODE WHERE O.CONTINENT = 'Asia';
Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than $2000 per month who have been employees for less than 10 months. Sort your result by ascending employee_id. Input Format The Employee table containing employee data for a company is described as follows: where employee_id is an employee's ID number, name is the..