🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

×
The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Q&A Hub

Q&A HubCategory: #SQL ×
22 hours ago
Hello! i have a problem with connecting to mySQL Server. I have already uninstalled the server and ...
Super Learner4 days ago
Hi, I'm on the Inner Joins lecture and I don't have the dept_manager_dup table in SQL. Where was it ...
1 week ago
DELIMITER $$ CREATE TRIGGER trig_ins_dept_mng AFTER INSERT ON dept_manager FOR EACH ROW BEGIN ...
8 months ago
For my mac os catalina 10.15, I am having problem to install  “MySQLWorkbench” can’t be ...
Super Learner2 weeks ago
Hello, I followed the instruction to install My SQL Server on Mac with homebrew and was successful. ...
Hi Team, I have a question about the stored procedure regarding the below code. USE employees;DROP ...
SELECT e.emp_no as employee_ID, min(de.dept_no) as dept_code, (SELECT emp_no from dept_manager ...
3 weeks ago
Hi! When I downloaded MySQL I think I must have skipped something in the installation section. I ...
4 weeks ago
19:15:41 insert into titles ( emp_no, title, from_date ) values ( 999903, 'Senior Engineer', ...
Super Learner2 months ago
Hi Martin,  I ran the query given in the solution of the lesson but found the solution a bit ...
Super Learner2 months ago
Hello! In the exercise, we had to display the number of department managers who were hired between ...
Super Learner2 months ago
What is the significance of the <> operator? { WHERE d.ddept_no <> dm.dept_no } In the ...
Super Learner3 months ago
INSERT INTO titles (emp_no,title,from_date)VALUES (999903,'Senior Engineer','1997-10-01' ); I am ...
Super Learner3 months ago
SELECT    *, AVG(salary) FROM    salaries WHERE    salary > 120000 GROUP BY emp_no ...
Super Learner3 months ago
SELECT emp_no, dept_no, COUNT(from_date) AS no_of_contracts FROM dept_emp WHERE ...