Give me some idea : How do I match photographer?

Question

I have photographer in my database such as PhotographerID, PhotographerName, JobArea, BestPhotography, FavoritePhotography.

And I want to match some photographer from my database.

The question that I will ask the user before matching photographer is..

Area or province that you want to hire a photographer?

Type of photography?

How do I match?

Answer 1

You should try to match the type of photographer that the user is asking for with the properties you have in your database.

Answer 2

SELECT PhotographerID, PhotographerName, JobArea, BestPhotography, FavoritePhotography
FROM Photographers
WHERE JobArea = 1