Writing SQL Queries Workbench

I’m having some trouble with writing this query. This is what I have so far: Find the name of the customer that deposited the highest amount with one transaction (include the transaction amount). …

issue with INNER JOIN in MYSQL 6.3

im trying to join data from two tables like this: Select portt.nameport, tool.weapen From Portt Where portt.toolsum – ( select count(*) From tool …

SQL group by get latest results

My question is in the picture: SQL query

MYSQL Procedure not getting called

The Following procedure after getting called, shows up error “The Result return more than one row” where the input value given is just one parameter. DELIMITER $$ CREATE PROCEDURE p( IN en …

No error message displayed on MYSQL Workbench latest version

I am running the latest version of MYSQL Workbench on a clean ubuntu 14.04 install, using the ubuntu package version. When I run a valid query, it works fine, e.g.: select * from users; At the …