AKM Mahmudul Islam

Thank you for your question. at first, you need to understand what your client or department chief asks for?

The task was- “Extract a dataset containing the following information about the managers: employee number, first name, and last name. Add two columns at the end – one showing the difference between the maximum and minimum salary of that employee, and another one saying whether this salary raise was higher than $30,000 or NOT.”

Here, you need to retrieve the information of the managers, that is why you can not execute the code without using dept_manager. you had executed the code and the result showed successfully, but if you look at the massage in the output section, you will see the difference. I hope you understand the matter.

I hope this file will help you out to get prepared for your upcoming examination mysql questions and answers

The rest of the course material will be published on 01 september In Sha Allah.

আপনি কোন database টি delete করতে চাচ্ছেন সেটা identify করেননি। use this syntax: drop database “”table_name””;

একটু লক্ষ্য করলেই দেখতে পাবেন schema section এ database টি create করা আছে “sale” নামে আর আপনি command করছেন “sales” নামের database এর জন্য। তাই এই ERROR টি দেখাচ্ছে।

ঈদের পর ইনশাআল্লাহ বাকি lessons গুলো upload হয়ে যাবে।

installation এর সময় mysql workbench and mysql server এর install স্ট্যাটাস কি complete হয়েছিল?
যদি হয়ে থাকে তাহলে নিচের স্টেপ গুলো follow করুন।
search option > service > find mySQL > select and mouse right click > Properties > go to log on option > select local system account > apply > OK
তারপর,
mySQL এ right click করে start করুন। server status: running show করবে।