Lets create a chatbot having a chat interface to give answers and also show graphs and plots for the results- Where I can ask questions from SQL. Basically put some template questions. Some of the sample questions can be:
1. What manufacture has shipment blocked for more than 1 week (In this u will see in sql in facility all manufacturer are listed and they have correspnding dwell time which means time shipment is there in a particular manfacturer so this question will provide me list of all manufacturer names which has dwell time more than 2 days).
2. How many shipments are in Walmart Arkansas, or Walmart mountain view or Costco Mountain view. (This question will provide me list of all shipments which are there in Walmart or Costco based on manufacturer type)
3. How many shipments in Pharma has temperature more than 50 degree fehrenite (This question will show me no of shipments).
