Find Candidates for Data Scientist Position II
[]
['Create table if not exists Candidates(candidate_id int, skill varchar(50), proficiency int)', 'Create table if not exists Projects( project_id int, skill varchar(50), importance int)', 'Truncate table Candidates', "insert into Candidates (candidate_id, skill, proficiency) values ('101', 'Python', '5')", "insert into Candidates (candidate_id, skill, proficiency) values ('101', 'Tableau', '3')", "insert into Candidates (candidate_id, skill, proficiency) values ('101', 'PostgreSQL', '4')", "insert into Candidates (candidate_id, skill, proficiency) values ('101', 'TensorFlow', '2')", "insert into Candidates (candidate_id, skill, proficiency) values ('102', 'Python', '4')", "insert into Candidates (candidate_id, skill, proficiency) values ('102', 'Tableau', '5')", "insert into Candidates (candidate_id, skill, proficiency) values ('102', 'PostgreSQL', '4')", "insert into Candidates (candidate_id, skill, proficiency) values ('102', 'R', '4')", "insert into Candidates (candidate_id, skill, proficiency) values ('103', 'Python', '3')", "insert into Candidates (candidate_id, skill, proficiency) values ('103', 'Tableau', '5')", "insert into Candidates (candidate_id, skill, proficiency) values ('103', 'PostgreSQL', '5')", "insert into Candidates (candidate_id, skill, proficiency) values ('103', 'Spark', '4')", 'Truncate table Projects', "insert into Projects (project_id, skill, importance) values ('501', 'Python', '4')", "insert into Projects (project_id, skill, importance) values ('501', 'Tableau', '3')", "insert into Projects (project_id, skill, importance) values ('501', 'PostgreSQL', '5')", "insert into Projects (project_id, skill, importance) values ('502', 'Python', '3')", "insert into Projects (project_id, skill, importance) values ('502', 'Tableau', '4')", "insert into Projects (project_id, skill, importance) values ('502', 'R', '2')"]
{"mysql": ["Create table if not exists Candidates(candidate_id int, skill varchar(50), proficiency int)", "Create table if not exists Projects( project_id int, skill varchar(50), importance int)"], "mssql": ["Create table Candidates(candidate_id int, skill varchar(50), proficiency int)", "Create table  Projects( project_id int, skill varchar(50), importance int)"], "oraclesql": ["Create table Candidates(candidate_id number, skill varchar2(50), proficiency number)", "Create table Projects(project_id number, skill varchar2(50), importance number)"], "database": true, "name": "find_best_candidates", "postgresql": ["CREATE TABLE IF NOT EXISTS Candidates (\n    candidate_id INT,\n    skill VARCHAR(50),\n    proficiency INT\n);\n", "CREATE TABLE IF NOT EXISTS Projects (\n    project_id INT,\n    skill VARCHAR(50),\n    importance INT\n);\n"], "pythondata": ["Candidates = pd.DataFrame({\n    'candidate_id': pd.Series(dtype='int'),\n    'skill': pd.Series(dtype='str'),\n    'proficiency': pd.Series(dtype='int')\n})", "Projects = pd.DataFrame({\n    'project_id': pd.Series(dtype='int'),\n    'skill': pd.Series(dtype='str'),\n    'importance': pd.Series(dtype='int')\n})"], "database_schema": {"Candidates": {"candidate_id": "INT", "skill": "VARCHAR(50)", "proficiency": "INT"}, "Projects": {"project_id": "INT", "skill": "VARCHAR(50)", "importance": "INT"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']