Find the guide last name and guide first name of all guides who can lead a paddling trip. (Note: The query results should include duplicate values.

select guide.last_name,guide.first_name
from guide,trip
where guide.state=trip.state and type='Paddling'
order by last_name,first_name;

but still had duplicates need to remove the duplicates

Answer rating: 100% (QA)

To remove duplicates from your query results you can use the DI... View the full answer