Note: please help me show fthe solution from the scratch. Input n read file Subject: java programming

Pls show the result of the solution

The following data contains information of guest staying at Hotel B stored in a text file named guest.txt. Each line contains the guest's room no, the guest's name, the type of room, breakfast option, total price for room and date of stay. Write a Java program with a method that does the following: i) Reads the input file guest.txt and display the information onto the screen ii) Count the number of guests who opt "Yes" for breakfast in the file and display the result onto the screen. Input file (guest.txt) 1501 Salina Mohd Sani Deluxe Yes 240 16-17/01/23 812 Abdullah Muhd Ismail Family No 3502425/01/23 1105 Chan Lee Wei Suite Yes 485 23-25/01/23 210 Mohd Firdhaus Hussin Executive Yes 6202224/01/23 608 David Anand Ravi Executive Yes 8451417/02/23 1209 Timothy Lee Anderson Single No 1801819/02/23 Sample Output Guests with a "Yes" for breakfast: 4