Zakaria Zahir22 hours ago
Hello! i have a problem with connecting to mySQL Server. I have already uninstalled the server and ...
Super LearnerZoe Draper4 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 ...
MINHEE SUNG1 week ago
DELIMITER $$ CREATE TRIGGER trig_ins_dept_mng AFTER INSERT ON dept_manager FOR EACH ROW BEGIN ...
Kuldeep Maan8 months ago
For my mac os catalina 10.15, I am having problem to install “MySQLWorkbench” can’t be ...
Super LearnerLisa Meyer2 weeks ago
Hello, I followed the instruction to install My SQL Server on Mac with homebrew and was successful. ...
Vinh Nguyá»…n ThĂ nh2 weeks ago
Hi Team, I have a question about the stored procedure regarding the below code. USE employees;DROP ...
Vinh Nguyá»…n ThĂ nh3 weeks ago
SELECT e.emp_no as employee_ID, min(de.dept_no) as dept_code, (SELECT emp_no from dept_manager ...
Anders Baumann3 weeks ago
Hi! When I downloaded MySQL I think I must have skipped something in the installation section. I ...
Tripti Kohli4 weeks ago
19:15:41 insert into titles ( emp_no, title, from_date ) values ( 999903, 'Senior Engineer', ...
Super LearnerArchisman Das2 months ago
Hi Martin, I ran the query given in the solution of the lesson but found the solution a bit ...
Super LearnerArchisman Das2 months ago
Hello! In the exercise, we had to display the number of department managers who were hired between ...
Super LearnerArchisman Das2 months ago
What is the significance of the <> operator? { WHERE d.ddept_no <> dm.dept_no } In the ...
Super LearnerArchisman Das3 months ago
INSERT INTO titles (emp_no,title,from_date)VALUES (999903,'Senior Engineer','1997-10-01' ); I am ...
Super LearnerArchisman Das3 months ago
SELECT Â Â Â *, AVG(salary) FROM Â Â Â salaries WHERE Â Â Â salary > 120000 GROUP BY emp_no ...
Super LearnerArchisman Das3 months ago
SELECT emp_no, dept_no, COUNT(from_date) AS no_of_contracts FROM dept_emp WHERE ...