Ask your self questions can help you think of what to measure, in order to get answers.
You need some more criteria. Is this a webpage? If so.. What language(s) are applicable for writing your web application. My profession is systems development, do I do a lot of fronte-end/ back-end development. I don't mind helping, just need some more information. If not what resource does this need to be created in?
Answer:
select style_name,br.name as brewery,count(beer_id) as Num
from beerdb.beers be
inner join beerdb.styles st
on be.style_id = st.style_id
join beerdb.breweries br on
be.brewery_id = br.brewery_id
group by style_name , br.name
having count(beer_id)>=10
order by style_name, num desc
Explanation:
Answer:
from socket import *
hostname = input('Enter the host to be scanned: ')
ip_add = gethostbyname(hostname)
connections = [ ]
for i in range(133, 136):
s = socket(AF_INET, SOCK_STREAM)
conn = s.connect_ex((ip_add, i))
print(conn)
connections.append(conn)
if 0 in connections:
print ('Host is online')
s.close()
else:
print ('system is unreachable')
Explanation:
The python source code above scans for all the available range of ports in the provided hostname, if any port is available, the host is online else the program print the error message "system is unreachable.